Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

how to bind Gridview in asp.net from database.

Anonymous User 1808 30 Oct 2015

i want to data bind in gridview using c# and asp.net . please help me if you know.

Ask by Anonymous User

Updated 30 Oct 2015

1 Answers

Anonymous User 30 Oct 2015

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

MindStick Training

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.