返回信息流SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = ".\\SQLExpress";
builder.InitialCatalog = "newhotel";
builder.IntegratedSecurity = true;
SqlConnection mySqlConnection = new SqlConnection(builder.ConnectionString);
mySqlConnection.Open();
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter("select * from myDB", mySqlConnection);
DataSet mySqlDataSet = new DataSet();
mySqlDataAdapter.Fill(mySqlDataSet,"myDB");
SqlCommandBuilder cb = new SqlCommandBuilder(mySqlDataAdapter);
mySqlDataAdapter.UpdateCommand = cb.GetUpdateCommand();
mySqlDataAdapter.InsertCommand = cb.GetInsertCommand();
mySqlDataAdapter.DeleteCommand = cb.GetDeleteCommand();
DataTable myDataTable = mySqlDataSet.Tables["myDB"];
mySqlConnection.Close();
mySqlDataSet.Tables["myDB"].Rows[0].Delete();
mySqlDataAdapter.Update(mySqlDataSet,"myDB");
代码是这样。。但是无法删除数据库表中内容。。求大牛帮看看。。[ema1]
这是一条镜像帖。来源：北邮人论坛 / database / #6796同步于 2012/5/22
Database机器人发帖
新手关于SQL操作问题。。
ljr140902
2012/5/22镜像同步0 回复
订阅后，新回复会通过你的通知中心匿名送达。
0 条回复
暂无回复 · 你可以订阅本帖等待新回复。