110,533
社区成员
发帖
与我相关
我的任务
分享
string s_SqlConnection = "data source=...;initial catalog=...;user id=...;password=...";
string s_SqlCommondText = "select * from argmst";
SqlConnection sqlCon = new SqlConnection(s_SqlConnection);
sqlCon.Open();
SqlDataAdapter sqlAdpt = new SqlDataAdapter(s_SqlCommondText, sqlCon);
SqlCommandBuilder bb = new SqlCommandBuilder(sqlAdpt);
sqlAdpt.Update(dall,"Table");
sqlCon.Close();
static private DataSet CreateCommandAndUpdate(
string connectionString,
string queryString)
{
DataSet dataSet = new DataSet();
using (OleDbConnection connection =
new OleDbConnection(connectionString))
{
connection.Open();
OleDbDataAdapter adapter =
new OleDbDataAdapter();
adapter.SelectCommand =
new OleDbCommand(queryString, connection);
OleDbCommandBuilder builder =
new OleDbCommandBuilder(adapter);
adapter.Fill(dataSet);
// Code to modify data in the DataSet here.
// Without the OleDbCommandBuilder, this line would fail.
adapter.UpdateCommand = builder.GetUpdateCommand();
adapter.Update(dataSet);
}
return dataSet;
}