Bind GridView in ASP.NET
IntroductionGrid view is a Data Source Control. Which represents the Data in form of a Table. Its architecture like a table. It have multiple rows and columns. Diagrammatic representations of Grid View shown below:
This table have 5 rows and 3 columns.
How to Bind Grid View using Programming
Before Bind Database table with Grid view, must connect with Database engine. DOTNET provides a Namespace, such as System.Data.SqlClient, which connects front-end to back-end. This Namespace contains multiple classes such as SqlConnection, SqlCommand and etc.
Front-end can connect with back-end using SqlConnection class. First of all, we create an object for it.
We can access the Data member and member function of class with the help of that object. such as
// Create an instance of SqlConnection class
SqlConnection con = new SqlConnection( );
// Access connection string using con instance.
con. ConnectionString = " Connection String Parameter ";
// Initialize connection string with database parameter
Some ConnectionString parameters which passes inside the ConnectionString. like
Data Source : Server Name;
Database Name : Name of your Database;
User-name : Database user name;
Password : Password of your Database
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"
Now, open the state of connection. Because state of connection close by default. So call open method from instance of SqlConnection class, such as
After making connection, you can access or delete data from Database table. CommandText property of SqlCommand class provide interface with Database table. You can access this property by instance of SqlCommand class, such as
Step-3SqlCommand cmd = new SqlCommand( );
cmd. CommandText = " Select * from [Table-name]";
This Query retrieves whole table of database. If you want to access particular column from table, must include column name inside the query. Like
cmd. CommandText = "Select column-name from [Table-name]";
Step-4Now, Connect SqlCommand class with Connection object using connection property of SqlCommand class.
cmd. Connection = con;
Step-5After fetching the data from database table, Read must from SqlDataReader class, which is inside in System.Data.SqlClient Namespace. Like
SqlDataReader rd= cmd. ExecuteReader( );
Step-6Bind GridView with DataReader. like
Gridview1. DataSource = rd;
Gridview1. DataBind( );
Complete Source code of Design pattern
<form id="form1" runat="server">
<asp:GridView ID="GridView1" runat="server">
Complete Business logic
public partial class Default5 : System.Web.UI.Page
protected void Page_Load(object sender, EventArgs e)
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * from [usertable]";
cmd.Connection = con;
SqlDataReader rd = cmd.ExecuteReader();
GridView1.DataSource = rd;