Newbie: Datagrid is Completely Blank?!?

Altemir · May 1, 2005

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 is
executed as plain HTML.

Code is as follows. Any ideas as to what could be going wrong?
--------------

<%@ 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>

Norman Yuan · May 1, 2005

Try to remove

MyDataGrid = New DataGrid()

from the seerver side script code: You already have the DataGrid created in
the HTML part and the variable "MyDataGrid" is originally pointed to the
DataGrid. Once you point the variable to a new DataGrid in your code, you
get a NEW data grid, which IS NOT the one you created in design stage (in
HTML part). The data will be bound to the DataGrid you just created in code.
Since the DataGrid you created in ocde is not added to the Page's control
collection, it will not show in the page, it only stays in server's memory
during the page loading and then be discarded. So, you page should be blank.

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 is
executed as plain HTML.

Code is as follows. Any ideas as to what could be going wrong?
--------------

<%@ 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>

Guest · May 1, 2005

Hi Altemir,

Sincem you don't explicitly declared columns for the datagrid, you need to
set
AutoGenerateColumns = ture. Otherwise there is no column to show data.

HTH

Elton Wang
(e-mail address removed)

Newbie: Datagrid Comes Up Blank?!?	3	Apr 30, 2005
Newbie Question	5	Apr 7, 2006
Error in displaying data grid	1	Dec 1, 2006
newbie question	2	Nov 10, 2003
ASP.net: Error "Exception Details: System.InvalidOperationException: The ConnectionString property h	6	Jun 15, 2004
how to search/replace items in specific column of a datatable	2	Feb 26, 2006
Simple Datagrid sort problem	0	Jan 6, 2004
DataGrid problem (newbie)	4	Nov 15, 2003

Newbie: Datagrid is Completely Blank?!?

Altemir

Norman Yuan

Guest

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads