DbCommandBuilder的问题，请教！！

Question

DbDataAdapter da = new DbDataAdapter();
da.SelectCommand = new DbCommand(select * from voucher_TB);//需设置其DbConnection...
DbCommandBuilder cb = new DbCommandBuilder(da);

Answer 1

修正:DbDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand(select * from voucher_TB);//需设置其SqlConnection...
DbCommandBuilder cb = new SqlCommandBuilder(da);

Answer 2

DbDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand(select * from voucher_TB);//需设置其SqlConnection...
DbCommandBuilder cb = new SqlCommandBuilder(da);// 不会自动获取增删改命令,需要手动获取
da.InserCommand = cb.GetInsertCommand();
da.UpdateCommand = cb.GetUpdateCommand();
da.DeleteCommand = cb.GetDeleteCommand();