Data Binding ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. Data Binding
  4. GridView DataBind
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs"  Inherits="GridViewDataBind" %>



    Untitled Page


    
    

        
        
    
    

    


File: Default.aspx.cs
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class GridViewDataBind : System.Web.UI.Page
{
  protected void Page_Load(object sender, System.EventArgs e)
  {
    if (!Page.IsPostBack)
    {
      string connectionString = "Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI";
      string sql = "SELECT EmployeeID, FirstName, LastName, Title, City FROM Employees";
      SqlConnection con = new SqlConnection(connectionString);
      SqlCommand cmd = new SqlCommand(sql, con);
      try
      {
        con.Open();
        SqlDataReader reader = cmd.ExecuteReader();
        grid.DataSource = reader;
        grid.DataBind();
        reader.Close();
      }
      finally
      {
        con.Close();
      }
    }
  }
}