Display data in Asp.net GridView

03/06/2017   01:06:09 PM

Hello,in this  asp.net tutorial i will explain how to display data in to Asp.net Gridview from sql server database.GridView in asp.net is very useful control,for display bulk data.it displays data in table format.Gridview has built in designing layout.it has advance properties like pagination,sorting,PagerSize,PagerStyle and easy update,delete data in GridView.

  

1 .Create a database name as Employee using SQL SERVER. Create a Table name as EmployeeDetails in this table create following fields

Columns Name        DataTypes

EmpId                     Int [Identity Property Set =True]

EmpName               varchar(50)

EmpDesgn              varchar(50)

 

2. Open VisualStudio.Net--> File-->New-->Web Site-->Select C#--> ASP.NET Empty Website

 

3. Add the webform into website.

for that open solution explorer-->right click on website folder name-->

add-->webform-->click on ok,Default.aspx webform will be added in to website


4.Add one GridView Control on webform

for that in visual studio-->View-->Toolbox-->Data-->GridView

 

5.Add the following code on Default.aspx 

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        <asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None">
            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
            <EditRowStyle BackColor="#999999" />
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#E9E7E2" />
            <SortedAscendingHeaderStyle BackColor="#506C8C" />
            <SortedDescendingCellStyle BackColor="#FFFDF8" />
            <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
        </asp:GridView>
    
    </div>
    </form>
</body>
</html>

 

 

6.Add the following code on Default.aspx.cs

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

public partial class _Default : System.Web.UI.Page
{
    SqlDataAdapter da = null;
    DataSet ds = null;
    SqlConnection cn = new SqlConnection(@"Data Source=.\sqlexpress;Initial Catalog=
Employee;Integrated Security=True");
    protected void Page_Load(object sender, EventArgs e)
    {

        da = new SqlDataAdapter("Select * From EmployeeDetails", cn);
        ds = new DataSet();
        da.Fill(ds, "EmployeeDetails");
        GridView1.DataSource = ds.Tables["EmployeeDetails"];
        GridView1.DataBind();

    }
}

 


Output

                   

Support us by Sharing