将datagrideview中编辑的数据保存到sql 要源码！！！

不要用linq to SQL 链接数据库打开 foreach(datagrideview)....保存到数据库...清空当前datagridview内容.......

http://www.w3dev.cn/demo/dgdemo.rar

 using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace Q691608
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=Q691608DB;Integrated Security=True;Pooling=False");
            conn.Open();
            foreach (DataGridViewRow row in dataGridView1.Rows)
            {
                try
                {
                    string sql = string.Format("insert into table1(姓名,工号,邮箱) values('{0}','{1}','{2}')", row.Cells[0].Value.ToString(), row.Cells[1].Value.ToString(), row.Cells[2].Value.ToString());
                    SqlCommand cmd = new SqlCommand(sql, conn);
                    cmd.ExecuteScalar();
                }
                catch { }
            }
            dataGridView1.Rows.Clear();
        }
    }
}

完整代码：https://download.csdn.net/download/dabocaiqq/10469159