Introduction:
The Grid View control is a powerful Data control that allows you to display the collection
of data, add sorting and paging, and perform inline editing. You can bind data
to the Grid View control in two different ways that is, using the DataSourceID
and the Data Source properties. In order to bind a data source control, set the
DataSourceID property of the Grid View control to the ID value of the data source
Control. Here, I explain
step-by-step how to retrieve data in a Grid View.
Prerequisites for this
tutorial:
- Visual studio(IDE)-2012 ultimate/professional/2013 express/any/2015
- SQl server 2008 sp2/14/12
Database :(Sql Server
2008 sp2)
Table
structures:
CREATE TABLE Department
(
dept_Id INT
NOT NULL PRIMARY KEY identity(1,1),
Name VARCHAR(30) unique
)
GO
CREATE TABLE Employee
(
emp_Id INT NOT NULL primary key Identity(1,1),
name varchar(50) unique,
city varchar(50),
dept_Id INT FOREIGN KEY REFERENCES
Department(dept_Id) on update cascade on delete cascade
)
GO
1.Department
Table
2.Employee Table
Application:
Step1: To create Login page first you need to open visual studio and run as administrator.
Step2: Go to File
Step3: Right click on File and Go to new
Step4: Choose either website or Project
Step5: A new template will be opened
Step6: Choose the language as Visual C# in left side
Step7: Select ASP.NET Empty website in right side.
Step8: Finally, in bottom specify the website is http, ftpsystem or file system
Step9: Choose HTTP,specify the name of the website at http://localhost/yourwebsitename andclick on ok.
Step10: if you chosen new project, skip 8 -9 steps and just specify the Solution name and directory enough. You have successfully created.
Step11: Go to Solution Explorer, Right Click on your application and Add new web form named as Bingridview Form.
Step12: To add Gird view on page, go to
toolbox -->find Grid
view --> drag and drop on to
designer page or source page.
Step13: Go to code behind file ... (bindgridview
.aspx.cs)
1. Bingridview.aspx
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Display
Data in Grid view</title>
<style>
.content
{
width:
45%;
margin:
0 auto;
margin-top:
75px;
}
th,td{
Line-height:
26px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div class="content">
<asp:
GridView ID="GridView1" runat="server" AutoGenerateColumns="false" CellPadding="5" ForeColor="#333333" GridLines="None">
<AlternatingRowStyle BackColor="White" ForeColor="#284775"></AlternatingRowStyle>
<Columns>
<asp:BoundField DataField="emp_Id" HeaderText="Employee
ID" ItemStyle-HorizontalAlign="Center" />
<asp:BoundField DataField="name" HeaderText="Employee
Name" ItemStyle-HorizontalAlign="Center" />
<asp:BoundField DataField="City" HeaderText="City" ItemStyle-HorizontalAlign="Center" ItemStyle-VerticalAlign="Middle" />
<asp:BoundField DataField="Dept" HeaderText="Department
Name" ItemStyle-HorizontalAlign="Center" />
</Columns>
<EditRowStyle BackColor="#999999"></EditRowStyle>
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White"></FooterStyle>
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White"></HeaderStyle>
<PagerStyle HorizontalAlign="Center" BackColor="#284775" ForeColor="White"></PagerStyle>
<RowStyle BackColor="#F7F6F3" ForeColor="#333333"></RowStyle>
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333"></SelectedRowStyle>
<SortedAscendingCellStyle BackColor="#E9E7E2"></SortedAscendingCellStyle>
<SortedAscendingHeaderStyle BackColor="#506C8C"></SortedAscendingHeaderStyle>
<SortedDescendingCellStyle BackColor="#FFFDF8"></SortedDescendingCellStyle>
<SortedDescendingHeaderStyle BackColor="#6F8DAE"></SortedDescendingHeaderStyle>
</asp:GridView>
</div>
</form>
</body>
</html>
2.bindgridview.aspx.cs
using
System;
using
System.Configuration;
using
System.Data;
using
System.Data.SqlClient;
using
System.Web;
using
System.Web.UI;
using System.Web.UI.WebControls;
namespace
gofaq
{
public partial class bindgridview
: System.Web.UI.Page
{
SqlConnection
con;
protected void
Page_Load(object sender, EventArgs
e)
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
if
(!Page.IsPostBack)
{
Display();
}
}
void
Display()
{
SqlCommand
cmd = new SqlCommand("Select
e.emp_Id, e.name, e.city, d.Name as Dept from Employee e,Department d Where
e.dept_Id=d.dept_Id", con);
if
(con.State != ConnectionState.Open)
con.Open();
SqlDataAdapter
da = new SqlDataAdapter(cmd);
DataSet
ds = new DataSet();
da.Fill(ds);
try
{
int
RowCount = ds.Tables[0].Rows.Count;
if
(RowCount > 0)
{
GridView1.DataSource =
ds.Tables[0];
GridView1.DataBind();
}
else
{
MessageBox("No
data exists to display");
}
}
catch
(Exception ex)
{
}
finally
{
if
(con.State != ConnectionState.Closed)
con.Close();
}
}
public void
MessageBox(string message)
{
ScriptManager.RegisterStartupScript(Page,
GetType(), "Key", string.Format("alert('{0}');",
message), true);
}
}
}
Output:
Press CTRL+F5
or F5 to run the page on server .
...for more information about previous tutorial please visit this link ASP.Net Tutorials and Thank you for visiting my blog ,don't forget to comment on post and if you want daily updates Just follow me in Google Plus.
