且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在c#中从datagridview将数据保存到数据库

更新时间: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[^]