生成DataAdapter的InsertCommand、UpdateCommand、DeleteCommand

最新推荐文章于 2020-04-24 08:47:31 发布

anzi6876

最新推荐文章于 2020-04-24 08:47:31 发布

阅读量574

点赞数

原文链接：http://www.cnblogs.com/liuhx1027/archive/2010/09/19/1831205.html

版权

OleDbCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT * FROM song WHERE 1=0";

OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.FillSchema(ds, SchemaType.Source, "song");
da.Fill(ds, "song");

//生成InsertCommand
OleDbCommandBuilder cmdBuilder = new OleDbCommandBuilder(da);
da.InsertCommand = cmdBuilder.GetInsertCommand();