Wednesday, February 21, 2007

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();


#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
/// 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);



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

No comments: