can't run classic asp code in header of aspx file

[Chumley the Walrus]

I'm trying to do some ASP date formatting in a separate include file
on my .aspx page, but I keep getting "Statement cannot appear within
method body, expected end of statement" error when running this page.
The header code begins as:
<%@ Page Language="VB" debug="true"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<!-- #include file=dayofweekparse.asp -->

<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim strConn as string
="SERVER=xxx.xxx.xx.xx;UID=xxxx;PWD=xxxx;DATABASE= xxxx;"
Dim strSQL as string ="select events from EventTable"
Dim Conn as New sqlConnection(strConn)
Dim Cmd as New sqlCommand(strSQL,Conn)
Conn.Open()
thedata.DataSource =
Cmd.ExecuteReader(system.data.CommandBehavior.Clos eConnection)
thedata.DataBind()
End Sub
</script>
????????

Chumley

[Steve C. Orr [MVP, MCSD]]

I doubt you'll have much luck trying to mix ASP and ASP.NET in the same page
like that. They are run by two completely separate engines, so this kind of
thing is not supported.
If you really need them to display together you might be able to get away
with putting an ASP page in one frame and an ASP.NET page in another frame.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Chumley the Walrus" <sp*******@yahoo.com> wrote in message
news:1e*************************@posting.google.co m...

I'm trying to do some ASP date formatting in a separate include file
on my .aspx page, but I keep getting "Statement cannot appear within
method body, expected end of statement" error when running this page.
The header code begins as:
<%@ Page Language="VB" debug="true"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<!-- #include file=dayofweekparse.asp -->

<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim strConn as string
="SERVER=xxx.xxx.xx.xx;UID=xxxx;PWD=xxxx;DATABASE= xxxx;"
Dim strSQL as string ="select events from EventTable"
Dim Conn as New sqlConnection(strConn)
Dim Cmd as New sqlCommand(strSQL,Conn)
Conn.Open()
thedata.DataSource =
Cmd.ExecuteReader(system.data.CommandBehavior.Clos eConnection)
thedata.DataBind()
End Sub
</script>
????????

Chumley

[Hermit Dave]

well i would suggest using iframe and set the src to the asp page you want
to display within asp.net page.

otherwise look up webclient class. you can refer to the asp file seperately.
read it into a string and then assign the html to a table cell

if you need any reference on specifics just let me know

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"Chumley the Walrus" <sp*******@yahoo.com> wrote in message
news:1e*************************@posting.google.co m...

I'm trying to do some ASP date formatting in a separate include file
on my .aspx page, but I keep getting "Statement cannot appear within
method body, expected end of statement" error when running this page.
The header code begins as:
<%@ Page Language="VB" debug="true"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<!-- #include file=dayofweekparse.asp -->

<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim strConn as string
="SERVER=xxx.xxx.xx.xx;UID=xxxx;PWD=xxxx;DATABASE= xxxx;"
Dim strSQL as string ="select events from EventTable"
Dim Conn as New sqlConnection(strConn)
Dim Cmd as New sqlCommand(strSQL,Conn)
Conn.Open()
thedata.DataSource =
Cmd.ExecuteReader(system.data.CommandBehavior.Clos eConnection)
thedata.DataBind()
End Sub
</script>
????????

Chumley

[Marina]

Of course this won't work. The include file becomes part of the .aspx page,
which expects .NET code. You can't put classic ASP there, unless its .NET
equivalent happens to be the same.

"Chumley the Walrus" <sp*******@yahoo.com> wrote in message
news:1e*************************@posting.google.co m...

I'm trying to do some ASP date formatting in a separate include file
on my .aspx page, but I keep getting "Statement cannot appear within
method body, expected end of statement" error when running this page.
The header code begins as:
<%@ Page Language="VB" debug="true"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<!-- #include file=dayofweekparse.asp -->

<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim strConn as string
="SERVER=xxx.xxx.xx.xx;UID=xxxx;PWD=xxxx;DATABASE= xxxx;"
Dim strSQL as string ="select events from EventTable"
Dim Conn as New sqlConnection(strConn)
Dim Cmd as New sqlCommand(strSQL,Conn)
Conn.Open()
thedata.DataSource =
Cmd.ExecuteReader(system.data.CommandBehavior.Clos eConnection)
thedata.DataBind()
End Sub
</script>
????????

Chumley

[Dwight Rau]

Scott Simons wrote:

asp != asp.net there is no #include. Also, there is built in datetime
parsing capability.

If there was no built in capability, what would be the best solution for
this situation? Would a user control (.ascx) be appropriate for this
situation? And just have that display the value?

[Jason Kester]

As others have mentioned, there is no #include style solution to your
problem. I've done this before though, and I imagine others have too,
as it seems like a likely thing to come up when you're halfway through
porting an asp app to .NET.

Basically, you'll need to do a web request to the .asp file that you
want to include, then spit the HTML out into your file.

Check out System.Net.WebRequest for ideas.

Jason
---

Expat Software Consulting Services
http://www.expatsoftware.com/

sp*******@yahoo.com (Chumley the Walrus) wrote in message news:<1e*************************@posting.google.c om>...

I'm trying to do some ASP date formatting in a separate include file
on my .aspx page, but I keep getting "Statement cannot appear within
method body, expected end of statement" error when running this page.
The header code begins as:
<%@ Page Language="VB" debug="true"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<!-- #include file=dayofweekparse.asp -->

<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim strConn as string
="SERVER=xxx.xxx.xx.xx;UID=xxxx;PWD=xxxx;DATABASE= xxxx;"
Dim strSQL as string ="select events from EventTable"
Dim Conn as New sqlConnection(strConn)
Dim Cmd as New sqlCommand(strSQL,Conn)
Conn.Open()
thedata.DataSource =
Cmd.ExecuteReader(system.data.CommandBehavior.Clos eConnection)
thedata.DataBind()
End Sub
</script>
????????

Chumley

[Lucas Tam]

Dwight Rau <dw*******@yahoo.com> wrote in news:emVMrY3mEHA.2340
@TK2MSFTNGP11.phx.gbl:

If there was no built in capability, what would be the best solution for
this situation? Would a user control (.ascx) be appropriate for this
situation? And just have that display the value?

Redo the code in .NET. Your code looks pretty straightforward.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/