Displaying Table Content In The DataGrid

This is the program to display the Table Content in The DataGrid

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace DisplayTableContent
{
///

/// Summary description for WebForm1.
///

public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DataGrid1;
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
SqlConnection con = new SqlConnection(@"server=servername;database=databasename;uid=username;pwd=password");
SqlDataAdapter sa = new SqlDataAdapter("Select * from tablename",con);
DataSet da=new DataSet();
sa.Fill(da,"CustomName");
DataGrid1.DataSource=da;
DataGrid1.DataBind();

}

#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
///

/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///

private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion
}
}



OutPut

To Set Template For DataGrid Right Click Over The Control And Select The AutoFormat From the Context menu and select your Scheme