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;}