How to bind C# Gridview using ADO.NET

The C# GridView Control

The C# GridView control is a Data bound control that displays the values of a data source in the form of a table . In this table , each column represents a field and each row represents a record . The C# GridView control exists within the System.Web.UI.Controls namespace . When you drag and drop the GridView control on the designer page , the following syntax is added to the source view of the page.

<asp:gridview id="GridView1" runat="server"> </asp:gridview>

ASP.NET reduce lots of code in binding process, provide binding controls such as SqlDataSource for connecting database. The GridView data control has a built-in capability of sorting ,paging , updating and deleting data. You can also set the column fields through the AutoGenerate property to indicate whether bound fields are automatically created for each field in the data source.
In the below mentioned example, step 1 is define for add gridview in the webpage. Now, come to second step create columns in the gridview, which is depend on user choice. Under the <Columns> tag, create TemplateFields, which is used for design first column, according to step 3.

STEP-1 : Drag Gridview from Toolbox and Drop on design window.

STEP-2 : Create columns inside Gidview

<asp:GridView ID="GridView1" runat="server">
<Columns >
</Columns>
</asp:GridView>

STEP-3 : Create first column using TemplateField

STEP-4 : Create ItemTemplate inside <asp:TemplateField>
STEP-5 : Also bind with table Attribute/Field

<asp:TemplateField>
<ItemTemplate>
<%# Eval("EmployeeId") %>
</ItemTemplate>
</asp:TemplateField>

STEP-6:
Make StoredProcedure for retrieving data from database table.

CREATE PROCEDURE [dbo].[getdata]

AS
SELECT * from [Table]

RETURN 0

STEP-7 : Create code for binding data

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;

public partial class binggrid : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page .IsPostBack)
{
getdataload();

}

}

private void getdataload()
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
con.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "getdata";
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
using (DataSet ds = new DataSet())
{
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();

}

}

}

}

}
}

Output of the program

Note : Some Extra Column appear in gridview like EmployeeId, name

if you want to remove these column add attribute inside gridview

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns ="false">

Main Output of the program are:

Here we are using single Template field. If you want to make more column then you must take more than one template field. Each template specifies column of the GridView.

Top related post