A
Altemir
Just trying to connect an ASP.NET page to an SQL database. When I run
the page, I get no errors but no recordset results are returned via the
datagrid control -- it is completely blank.
The only thing displayed is the "Job Dispatch List" page title which
executed as plain HTML.
Code is as follows. Any ideas?
--------------
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<HTML>
<SCRIPT language="VB" runat="server">
Sub Page_Load(Sender As Object, E As EventArgs)
Dim MyDataset As DataSet
Dim MyConnection As SqlConnection
Dim MyDataAdapter As SqlDataAdapter
Dim myDataGrid as DataGrid
MyConnection = New SqlConnection("Data Source=apollo;Initial
Catalog=ProductionStatus;uid=sa;pwd=mypassword" )
MyDataAdapter = New SqlDataAdapter("SELECT ID FROM dbo_PART",
MyConnection)
MyDataset = New DataSet()
MyDataAdapter.Fill(MyDataset,"Parts")
MyDataGrid = New DataGrid()
MyDataGrid.DataSource=MyDataset.Tables("Parts")
MyDataGrid.DataBind()
End Sub
</SCRIPT>
<TITLE>Job Dispatch List</TITLE>
<BODY>
<H3><font face="Arial">Job Dispatch List</font></H3>
<ASP
ataGrid id="MyDataGrid" runat="server"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="true"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false"
/>
</BODY>
</HTML>
the page, I get no errors but no recordset results are returned via the
datagrid control -- it is completely blank.
The only thing displayed is the "Job Dispatch List" page title which
executed as plain HTML.
Code is as follows. Any ideas?
--------------
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<HTML>
<SCRIPT language="VB" runat="server">
Sub Page_Load(Sender As Object, E As EventArgs)
Dim MyDataset As DataSet
Dim MyConnection As SqlConnection
Dim MyDataAdapter As SqlDataAdapter
Dim myDataGrid as DataGrid
MyConnection = New SqlConnection("Data Source=apollo;Initial
Catalog=ProductionStatus;uid=sa;pwd=mypassword" )
MyDataAdapter = New SqlDataAdapter("SELECT ID FROM dbo_PART",
MyConnection)
MyDataset = New DataSet()
MyDataAdapter.Fill(MyDataset,"Parts")
MyDataGrid = New DataGrid()
MyDataGrid.DataSource=MyDataset.Tables("Parts")
MyDataGrid.DataBind()
End Sub
</SCRIPT>
<TITLE>Job Dispatch List</TITLE>
<BODY>
<H3><font face="Arial">Job Dispatch List</font></H3>
<ASP
ataGrid id="MyDataGrid" runat="server"Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="true"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false"
/>
</BODY>
</HTML>