ASP.NET

Any Simple Code for binding data with gridview?

Please support our ASP.NET advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Nov 2009

Posts: 3

Reputation: diru is an unknown quantity at this point

Solved Threads: 0

diru

Offline

Newbie Poster

Any Simple Code for binding data with gridview?

Nov 2nd, 2009

Anyone can help me to give link or website / tutorial about binding data with gridview ??....

•

Join Date: Aug 2008

Posts: 63

Reputation: love_dude1984 is an unknown quantity at this point

Solved Threads: 2

love_dude1984 love_dude1984 is offline

Offline

Junior Poster in Training

Nov 3rd, 2009

Try this:

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
 
 SqlConnection cn = new SqlConnection("Your ConnectionsString here");
        SqlCommand cmd = new SqlCommand("Query to Retrieve data from database",cn);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds, "Data");
 
 
        gridview.DataSource = ds.Tables[0];
        gridview.DataBind();
 SqlConnection cn = new SqlConnection("Your ConnectionsString here");
        SqlCommand cmd = new SqlCommand("Query to Retrieve data from database",cn);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds, "Data");

        
        gridview.DataSource = ds.Tables[0];
        gridview.DataBind();