更新时间:2022-10-25 08:50:12
做这样的事情......for ( int i = 0 ; I< dataGridView1.Rows.Count-1; i ++)
{
Strquery = @ 插入yourTableName (date,column1,....)值(
+ System.DateTime.Now + ,
+ dataGridView1.Rows [i] .Cells [ 1 ]。值+ .......);;
cmd.CommandText = Strquery;
cmd.ExecuteNonQuery();
}
或者,请关注此帖子..
http://social.msdn.microsoft.com/Forums/en -US / 8cee37d0-732b-4fa9-a88c-4f46a2202a06 / how-to-save-datagridview-data-into-a-database [ ^ ]
how to save send data into database in c# from gridview
[Edit - additional details from repost]
How to save send data into database in c# from gridview
means i want to save all of data from gridview to database with one time button click..
as like we save from textboxes
insert into table values(datagridview1.column1 + "," + datagridview1.column2 + "," + datagridview1.column2 +");
Do something like this..for(int i=0; i< dataGridView1.Rows.Count-1;i++) { Strquery= @"Insert into yourTableName(date,column1,....) values (" + System.DateTime.Now +", " + dataGridView1.Rows[i].Cells[1].Value +".......);"; cmd.CommandText = Strquery; cmd.ExecuteNonQuery(); }
Or,follow this post..
http://social.msdn.microsoft.com/Forums/en-US/8cee37d0-732b-4fa9-a88c-4f46a2202a06/how-to-save-datagridview-data-into-a-database[^]