namespace DategridviewToSQL { public partial class Form1 : Form { private DataTable DT = new DataTable(); private SqlDataAdapter SDA = new SqlDataAdapter(); private Boolean isUpdate = false; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { load(); } private void load() { SqlConnection conn = new SqlConnection(@"server = (local)\SQL2005;Integrated Security = true;" + "DataBase = test1"); SqlCommand SCD = new SqlCommand("select * from aaa ", conn); SDA.SelectCommand = SCD; SDA.Fill(DT); dataGridView1.DataSource = DT; } private void button1_Click(object sender, EventArgs e) { if (isUpdate) { try { SqlCommandBuilder SCB = new SqlCommandBuilder(SDA); SDA.Update(DT); isUpdate = false; } catch (System.Exception ex) { MessageBox.Show(ex.ToString()); return; } MessageBox.Show("更新成功! "); } else { MessageBox.Show("没有更新内容! "); } for (int i = 0; i < DT.Rows.Count; i++) for (int j = 0; j < DT.Columns.Count; j++ ) { dataGridView1[j, i].Style.BackColor = Color.White; } } private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { isUpdate = true; dataGridView1[e.ColumnIndex,e.RowIndex].Style.BackColor = Color.Blue; }
在DataGridView中修改后的数据如何保存到数据库
最新推荐文章于 2023-06-02 15:35:25 发布