Datagridview实现自动更新到数据库

针对Access数据库介绍使用方法

DataTable tb;
OleDbDataAdapter da;
private void bindData()
{
    string dateStr = DateTime.Now.ToShortDateString();
    tb = db.QueryTable("select [account].[id] ,[pid],[account].[username],[account].[password],[account].[otherdata],iif(isnull(success),'-',success)  as state from account left join [record] on ([aid]=[account].[id]  and [record].[getDate]='" + dateStr + "') where ( [pid]=" + IDIndex.ToString() + ")");
    OleDbConnection con = new OleDbConnection(db.connectionString);
    da = new OleDbDataAdapter("select * from account ", con);
    OleDbCommandBuilder scb = new OleDbCommandBuilder(da);//可自动生成更新，插入，删除sql语句
    scb.QuotePrefix = "[";
    scb.QuoteSuffix = "]";
            
    dataGridView1.DataSource = tb;
}

主要是通过OleDbCommandBuilder来实现的，这里需要注意的是不需要手动给OleDbCommandBuilder设置删、改的语句，但是如果查询语句很复杂是无法正确生成删、改的语句的，所以要手动设置一个最简单的查询语句，很简单吧，几行代码就搞定一切。