Dynamic Gridview binding c#

Hi,Pls try to below logic...........
DataTable dt = new DataTable();
DataRow dr = null;
dt.Columns.Add(new DataColumn("Count", typeof(string)));
dt.Columns.Add(new DataColumn("hour", typeof(string)));
dt.Columns.Add(new DataColumn("date", typeof(string)));

dr["Count"] = grdview.Rows[row.RowIndex].Cells[1].Text.ToString();
dr["hour"] = grdview.Rows[row.RowIndex].Cells[2].Text.ToString();
dr["date"] = System.DateTime.Now.ToString("dd/MM/yyyy");

dt.Rows.Add(dr);
gvReport.DataSource = dt;
gvReport.DataBind();

(OR)

if get the values from the data base table write stored procedure and call that procedure to dataset and add that dataset gridview.

Ex: dataset ds=new dataset();
ds="select count,hour,date from tablename";
gvReport.DataSource = ds;
gvReport.DataBind();

Rajasekhar0544, if this helps please login to Mark As Answer. | Alert Moderator

Hi Friend

i think it helps you...
on button click event.....

 con.Open(); //open your Sql connection

            MySqlCommand cmd = new MySqlCommand("select * from Your_table", con);

            MySqlDataAdapter da = new MySqlDataAdapter(cmd);

            DataTable dt = new DataTable();

            da.Fill(dt);

            GridView2.DataSource = dt; //now store data table

            GridView2.DataBind(); //and finally bind the data with data grid you

con.Close();

Shubham Agrahari

Rajasekhar0544, if this helps please login to Mark As Answer. | Alert Moderator

ya rajesh !!!! Shubh is right
only pass the connecting string on it

Thanks&Regards:-
Shubham Choudhary
Software Engineer
www.facebook.com/shubham.kunar

Rajasekhar0544, if this helps please login to Mark As Answer. | Alert Moderator

Bind GridView to data in C# Windows Forms application.
http://www.kettic.com/winforms_ui/csharp_guide/gridview_populate_data.shtml

Rajasekhar0544, if this helps please login to Mark As Answer. | Alert Moderator