forum

home / developersection / forums / how to bind gridview in asp.net from database.

Ask Question

how to bind Gridview in asp.net from database.

Anonymous User 1635 30-Oct-2015
i want to data bind  in gridview  using c# and asp.net . please help me if you know.
.net c#  asp.net 
Updated on 30-Oct-2015
Anonymous User

Other

I am a content writter !

Message
Can you answer this question?
Answer

1 Answers

Anonymous User

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
how to bind Gridview  in asp.net from database.
advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy