GridView.DataBind Method ()
.NET Framework 2.0
Note: This method is new in the .NET Framework version 2.0.
Binds the data source to the GridView control. This method cannot be inherited.
Namespace: System.Web.UI.WebControls
Assembly: System.Web (in system.web.dll)
Assembly: System.Web (in system.web.dll)
The following code example demonstrates how to use the DataBind method to bind a data source to a GridView control.
<%@ Page language="C#" %> <%@ import namespace="System.Data" %> <%@ import namespace="System.Data.SqlClient" %> <script runat="server"> void Page_Load(Object sender, EventArgs e) { // This example uses Microsoft SQL Server and connects // to the Northwind sample database. The data source needs // to be bound to the GridView control only when the // page is first loaded. Thereafter, the values are // stored in view state. if(!IsPostBack) { // Declare the query string. String queryString = "Select [CustomerID], [CompanyName], [Address], [City], [PostalCode], [Country] From [Customers]"; // Run the query and bind the resulting DataSet // to the GridView control. DataSet ds = GetData(queryString); if (ds.Tables.Count > 0) { AuthorsGridView.DataSource = ds; AuthorsGridView.DataBind(); } else { Message.Text = "Unable to connect to the database."; } } } DataSet GetData(String queryString) { // Retrieve the connection string stored in the Web.config file. String connectionString = ConfigurationManager.ConnectionStrings["NorthWindConnectionString"].ConnectionString; DataSet ds = new DataSet(); try { // Connect to the database and run the query. SqlConnection connection = new SqlConnection(connectionString); SqlDataAdapter adapter = new SqlDataAdapter(queryString, connection); // Fill the DataSet. adapter.Fill(ds); } catch(Exception ex) { // The connection failed. Display an error message. Message.Text = "Unable to connect to the database."; } return ds; } </script> <html> <body> <form runat="server"> <h3>GridView DataBind Example</h3> <asp:label id="Message" forecolor="Red" runat="server"/> <br/> <asp:gridview id="AuthorsGridView" autogeneratecolumns="true" runat="server"> </asp:gridview> </form> </body> </html>
Windows 98, Windows 2000 SP4, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.
