Retrieving Data in GridView in ASP.Net

Introduction

A Grid View is a graphical control element that presents a tabular view of data. A Grid View is used to represent a list of data items by binding data fields to columns and displaying columns. A typical Grid View supports features like click, drag and drop, in place edit and so on.

Here I explain step-by-step how to retrieve data in a Grid View.

Step 1

Start Visual Studio.

Visual Studio Start Page

Step 2

Select the project from the File menu.

Creating New Project

Step 3

Choose web and select ASP.NET Web Application.

Creating Asp.Net Web Application

Step 4

Now add an empty project template for creating the ASP.NET Web Application.

Selecting Project Template

Step 5

Select the project located in the menu bar and choose ADD NEW ITEM and select WEB PAGE and provide a meaningful name.

Creating Web Form

Place the following code in your web form page:

<asp:GridView ID="grid1" runat="server" AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333" GridLines="None" >
<AlternatingRowStyle BackColor="White" />
<columns>
<asp:TemplateField HeaderText="EmployeeID">
<ItemTemplate>
<asp:Label ID="LblCompanyId" runat="server" Text='<%#Bind("c_id") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Name">
<ItemTemplate>
<asp:Label ID="LblCompanyName" runat="server" Text='<%#Bind("c_name") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Address">
<ItemTemplate>
<asp:Label ID="LblCompanyAddress" runat="server" Text='<%#Bind("c_address") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Phone">
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%#Bind("c_mobile") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Date Time">
<ItemTemplate>
<asp:Label ID="LblDate" runat="server" Text='<%#Bind("Date") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</columns>
<EditRowStyle BackColor="#2461BF" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F5F7FB" />
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
<SortedDescendingCellStyle BackColor="#E9EBEF" />
<SortedDescendingHeaderStyle BackColor="#4870BE" />
</asp:GridView>

This function is used to fetch data from the company table and display it on the Grid View. It fills in the data in a DataTable object and binds it to a GridView control using the DataSource property. In the end, the code calls the GridView. DataBind method to apply the binding.

Code

public partial class Asp : System.Web.UI.Page
{
SqlConnection con;
public Asp()
{
con = new SqlConnection("Your Connection String");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DisplayRecord();
}
}
public DataTable DisplayRecord()
{
SqlDataAdapter Adp = new SqlDataAdapter("select * from company", con);
DataTable Dt = new DataTable();
Adp.Fill(Dt);
grid1.DataSource = Dt;
grid1.DataBind();
return Dt;
}
}

Output

GridView in Asp.Net

7 Comments

Join the conversation! Your thoughts help the community grow.

Mohd Anish7y ago
Hi there, how I add paging in gridview
Prashanth Akula9y ago
Thank u bro its working
Shashikant singh11y ago
good
Sujeet Suman11y ago
Nice Article..................
Saineshwar Bageri12y ago
nice start
Chirag Raheja12y ago
Keep it up
Nimit Joshi12y ago
Good Start..