在c＃中从datagridview将数据保存到数据库 [英] Save Data to Database from datagridview in c#

问题描述

如何在c＃中从gridview保存发送数据到数据库





如何保存发送从gridview c＃到数据库的数据

表示我想通过一次点击按钮将所有数据从gridview保存到数据库..

就像我们从文本框保存一样

 插入 进入 表 值（datagridview1.column1 +  ， + datagridview1.column2 +  ，  + datagridview1.column2 +  ）;  

解决方案

做这样的事情......

  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[^]

这篇关于在c＃中从datagridview将数据保存到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！