Hi,
VB script written inside the aspx file is not working.
Here is the code.
<%@ import namespace= "system.data.oledb"%>
<%@ Import namespace="System.Data"%>
<%@ Page Language="
vb" AutoEventWireup="false" src="aspnet101.aspx.
vb" Inherits="aspnet101"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>aspnet101</title>
<script language="
VB" runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
Dim count As Integer
Dim fldName As String
Dim strConn As String = "Provider=MSDAORA.1;Password=demo;User ID=demo;Data Source=tst1;"
Dim MySQL As String = "Select * from project"
Dim MyConn As New OleDbConnection(strConn)
Dim objDR As OleDbDataReader
Dim Cmd As New OleDbCommand(MySQL, MyConn)
MyConn.Open()
Response.Write("jkjsdasdas")
Try
objDR = Cmd.ExecuteReader(system.data.CommandBehavior.Clos eConnection)
For count = 0 To objDR.FieldCount - 1
lstFields.Items.Add(objDR.GetName(count))
Next count
Catch ex As Exception
Response.Write(ex.Message)
Finally
MyConn.Close()
End Try
end sub
</script>
<meta name="vs_showGrid" content="True">
<meta name="GENERATOR" content="Microsoft Visual Studio.NET 7.0">
<meta name="CODE_LANGUAGE" content="Visual Basic 7.0">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<asp:ListBox id="lstFields" Runat="server" />
</form>
</body>
</HTML>
If same code placed inside aspx.
vb file, it works fine. Can anyone give solution.
I'm using VS.NET 1.0.
Thanks,
Apry
vb script is not working
