---
title: "how to bind Gridview  in asp.net from database."  
description: "how to bind Gridview  in asp.net from database."  
author: "Anonymous User"  
published: 2015-10-30  
updated: 2015-10-30  
canonical: https://www.mindstick.com/forum/33550/how-to-bind-gridview-in-asp-dot-net-from-database  
category: ".net"  
tags: ["c#", "asp.net"]  
reading_time: 1 minute  

---

# how to bind Gridview  in asp.net from database.

i want to [data](https://www.mindstick.com/articles/13050/salesforce-aiming-to-dominate-predictive-analytics-with-data-science) bind in [gridview](https://www.mindstick.com/articles/873/update-delete-edit-gridview-in-asp-dot-net) using c# and [asp.net](https://www.mindstick.com/articles/934/default-folders-available-inside-the-asp-dot-net-application-folder) . please help [me if](https://answers.mindstick.com/qa/50259/tell-me-if-your-system-is-infected-by-a-virus-how-you-will-recover-the-data) you know.

## Replies

### Reply by Anonymous User

The GridView control displays the values of a data source in a table. Each column represents a field, while each row represents a record. It is server control in asp.net.

```
  <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#CC9966" BorderStyle="Solid" BorderWidth="1px" CellPadding="4">
        <Columns>
            <asp:TemplateField HeaderText="Emp_ID">
                <ItemTemplate>
                    <%#Eval("Emp_ID") %>
                </ItemTemplate>                <ControlStyle Width="100px"></ControlStyle>
                <HeaderStyle Width="100px" />                <ItemStyle HorizontalAlign="Center" />
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Emp_Name">
                <ItemTemplate>
                    <%#Eval("Emp_Name") %>
                </ItemTemplate>
                <ControlStyle Width="300px"></ControlStyle>
                <HeaderStyle Width="200px" />
            </asp:TemplateField>            <asp:TemplateField HeaderText="Emp_Sal">                <ItemTemplate>
                    <%#Eval("Emp_Sal") %>
                </ItemTemplate>
                <ControlStyle Width="200px"></ControlStyle>
                <HeaderStyle Width="200px" />
            </asp:TemplateField>
        </Columns>
        <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
        <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
        <PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
        <RowStyle BackColor="White" ForeColor="#330099" />        <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
        <SortedAscendingCellStyle BackColor="#FEFCEB" />
        <SortedAscendingHeaderStyle BackColor="#AF0101" />
        <SortedDescendingCellStyle BackColor="#F6F0C0" />
        <SortedDescendingHeaderStyle BackColor="#7E0000" />
    </asp:GridView>  string constr = ConfigurationManager.ConnectionStrings["forumConnectionString"].ToString(); // connection string            SqlConnection con = new SqlConnection(constr);            con.Open();
             SqlCommand com = new SqlCommand("select *from Employee", con); // table name
            SqlDataAdapter da = new SqlDataAdapter(com);
            DataSet ds = new DataSet();
            da.Fill(ds);  // fill dataset
            GridView1.DataSource = ds.Tables[0]; //set DataSource GridView
            GridView1.DataBind(); //binding GridView
```

```

```


---

Original Source: https://www.mindstick.com/forum/33550/how-to-bind-gridview-in-asp-dot-net-from-database

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.