How to bind a GridView in ASP.net

[vivek kapile]

This code will help for the beginners, who want to learn, how to bind a gridview.

Before showing the code I will give a small introduction how to work with gridview.

1. Add a gridview controls to the ASPX Page.
2. Create a method to get a data from the database and bind to the gridview
3. Create a dataset object.
4. create a sqlcommand object.
5. create a sqlconnection object

Description:
Below is a sample code.

In ASPX Page

     <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="true">
 
        </asp:GridView>
 

IN ASPX.CS File

    protected void Page_Load(object sender, EventArgs e)
        {
 
             GetData();
 
        }
    void GetData()
        {
            DataSet ds = new DataSet();
            SqlCommand cmd = new SqlCommand();
            SqlDataAdapter da = new SqlDataAdapter();
            SqlConnection con = new SqlConnection("Data Source=msdb;Initial Catalog=TEST;Persist Security Info=True;User ID=sa;Password=sa");
            if (con.State == ConnectionState.Open)
                con.Close();
            else
                con.Open();
            cmd.CommandText = "Select * from Platform";
            cmd.Connection = con;
            da.SelectCommand = cmd;
            da.Fill(ds);
            cmd.ExecuteNonQuery();
            GridView1.DataSource = ds;
            GridView1.DataBind();
        }
 

Summary
There are many topics to learn with ASP.Net. I have covered a small portion hope this will helps all the beginners to startup. Please give your feedback and suggestion.