.Net Learning made easy: How to Bind GridView in Asp.Net

Here we are binding a GridView in Asp.Net.

Here we are using Column BoundField for Changing header name.

Points Of Remember:

1. Add namespace System.Data and System.Data.SqlClient in your C# page.

<!DOCTYPE html>

<title>Bind GridView in Asp.net</title>

</head>

<body>

<div>

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

CellPadding="4" ForeColor="#333333">

<asp:BoundField DataField="Name" HeaderText="Student Name" />

<asp:BoundField DataField="Branch" HeaderText="Branch" />

<asp:BoundField DataField="City" HeaderText="City Name" />

</Columns>

</asp:GridView>

</div>

</form>

</body>

</html>

Here we are using ADO.Net to bind student table values into GridView.

C# Codes :

using System.Data;

using System.Data.SqlClient;

public partial class GridView : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindGridView();

}

//method for binding GridView

protected void BindGridView()

{

DataTable dt = new DataTable();

SqlConnection con = new SqlConnection(@"Data Source=RAVI-PC\SQL;Initial Catalog=db_Student;Integrated Security=True");

SqlDataAdapter da = new SqlDataAdapter("Select Name,Branch,City from tbl_student",con);

con.Open();

da.Fill(dt);

con.Close();

if (dt.Rows.Count > 0)

{

GridView1.DataSource = dt;

GridView1.DataBind();

}

View output :

Now over to you:


"A blog is nothing without reader's feedback and comments. So please provide your valuable feedback so that i can make this blog better and If you like my work; you can appreciate by leaving your comments. Stay tuned and stay connected for more technical updates."

.Net Learning made easy

my own pages

Sunday, February 8, 2015

How to Bind GridView in Asp.Net

Points Of Remember:

C# Codes :

View output :

No comments:

Post a Comment