Microsoft KB Archive/313156

= PRB: DataGrid Control Does Not Display Correctly in .aspx Page =

Article ID: 313156

Article Last Modified on 10/30/2003

-

APPLIES TO


 * Microsoft ASP.NET 1.0
 * Microsoft ASP.NET 1.1

-



This article was previously published under Q313156



This article refers to the following Microsoft .NET Framework Class Library namespace:
 * System.Data.SqlClient



SYMPTOMS
When you view an .aspx page that contains a DataGrid control, the data grid may not appear. Alternately, only the header of the data grid may appear, but the data grid may not contain any data.



Data Grid Does Not Appear
The data grid does not appear at all if:
 * You do not set the DataSource property of the DataGrid control. -or-


 * You do not call the DataBind method of the DataGrid control or the DataBind method of the Page object from your code.

Data Grid Header Appears But Data Grid Is Empty
The data grid header appears, but the data grid does not contain any data if:
 * The data source does not contain any data. -or-


 * You do not fill the dataset that is bound to the DataGrid with data at run time.

NOTE: You must write code to explicitly fill the dataset so that the DataGrid is populated with data from the database at run time. You can do this when you use the designer to add the DataAdapter object and to generate a dataset at design time.

This problem occurs because the .aspx page retrieves the details of the header fields from the .xsd file. The .xsd file is created for each dataset when you generate a dataset at the design time. This file contains the Extensible Markup Language (XML) representation of the dataset. The .aspx page retrieves the header field details from this file. Therefore, the data grid header appears but the data grid is empty.



Data Grid Does Not Appear
To resolve this problem, follow these steps:   Set the DataSource property of the DataGrid to point to the appropriate data source. For example:

Visual Basic DataGrid1.DataSource = dataSet11.Tables(&quot;Authors&quot;) Visual C# DataGrid1.DataSource = dataSet11.Tables[&quot;Authors&quot;] ; NOTE: If you programmatically retrieve the data from the data source, assign the data source to the DataSource property of the DataGrid.  If you use the designer to add a DataAdapter to the Web form and to generate a dataset, open the DataGrid property page, and then select the appropriate DataSet or DataView object in the DataSource property.  Call the DataBind method of the DataGrid control or the DataBind method of the Page object. For example:

Visual Basic 'Use one of the following lines. 'Page.DataBind DataGrid1.DataBind Visual C# //Use one of the following lines. //Page.DataBind; DataGrid1.DataBind; 

Data Grid Header Appears But Data Grid Is Empty
To resolve this problem, follow these steps:  Make sure your that your data source contains data and that your query returns data.  Use a DataAdapter to fill the dataset. For example:

Visual Basic sqlDataAdapter1.Fill(dataSet11, &quot;Authors&quot;) Visual C# sqlDataAdapter1.Fill(dataSet11,&quot;Authors&quot;); </li></ol>

<div class="status_section">

STATUS
This behavior is by design.

<div class="moreinformation_section">

MORE INFORMATION
You must bind the DataGrid Web server control to a data source through the DataSource property of the DataGrid to correctly render the data grid on the page. After you set the data source, you must also explicitly call the DataBind method of the DataGrid control or the DataBind method of the Page object from your code.

Data Grid Does Not Appear
 Create a new ASP.NET Web Application project in Visual Basic .NET or Visual C# .NET.</li> Drag a DataGrid control from the toolbox, and drop the control onto the form.</li>  In the designer, double-click the .aspx page to open the code-behind window. Add the following code to the top of the code-behind window to add the required namespace references:

Visual Basic Imports System.Data Imports System.Data.SqlClient Visual C# using System.Data.SqlClient; </li>  Replace the code in the Form_Load event with the following code:

Note You must change uid = and pwd = to the correct values before you run this code. Be sure that UID has the appropriate permissions to perform this operation on the database.

Visual Basic Private Sub Page_Load(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles MyBase.Load 'Write code to access the database. Dim myConnection As New SqlConnection(&quot;server=(local);database=pubs;uid= ;pwd= &quot;) Dim myDataAdapter As New SqlDataAdapter(&quot;select * from authors&quot;, myConnection) Dim myDataSet As New DataSet myConnection.Open myDataAdapter.Fill(myDataSet)

'Uncomment the following line to resolve this problem. 'DataGrid1.DataSource = myDataSet DataGrid1.DataBind End Sub Visual C# private void Page_Load(object sender, System.EventArgs e) { //Write code to access the database. SqlConnection myConnection = new SqlConnection(&quot;server=(local);database=pubs;uid= ;pwd= &quot;); SqlDataAdapter myDataAdapter = new SqlDataAdapter(&quot;select * from authors&quot;, myConnection); DataSet myDataSet = new DataSet; myConnection.Open; myDataAdapter.Fill(myDataSet);

//Uncomment the following line to resolve this problem. //DataGrid1.DataSource = myDataSet; DataGrid1.DataBind; }                   </li> Modify the connection string as appropriate for your environment.</li> Build the project, and then view the .aspx page in the browser. Notice that data grid does not appear.</li></ol>

Data Grid Header Appears But Data Grid Is Empty
 Create a new ASP.NET Web Application project in Visual Basic .NET or Visual C# .NET.</li> Drag a DataGrid control from the toolbox, and drop the control onto the form.</li> Add a SqlDataAdapter control to the Web form. Complete the following steps in the DataAdapter Configuration Wizard to set the connection properties:  Click New Connection to create a new connection to your Microsoft SQL Server database. Select the server, type the logon information, and then select the Pubs database.</li> Under Query type, click SQL Statements, and then click Next.</li>  Type the following SQL statement: Select * From Authors </li> <li>Click Finish.</li></ol> </li> <li>Right-click the DataAdapter, and then click Generate Dataset.</li> <li>Set the DataSource property of the DataGrid to the dataset that is generated.</li> <li> In the designer, double-click the .aspx page to open the code-behind window. Add the following code to the Page_Load event:

Visual Basic DataGrid1.DataBind Visual C# DataGrid1.DataBind; </li> <li>Build the project, and then view the .aspx page in the browser. Notice that the header of the data grid appears, but the data grid does not contain any data.</li></ol>

<div class="references_section">