给你一个例子:
private void DataSetUpdate(string Datatablename, string sqlstr)
{
try
{
SqlDataAdapter adapter = new SqlDataAdapter(sqlstr, new SqlConnection(SqlHelper.ConnectionString));
SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(adapter);
adapter.DeleteCommand = new SqlCommand("", new SqlConnection(SqlHelper.ConnectionString));
adapter.InsertCommand = new SqlCommand("", new SqlConnection(SqlHelper.ConnectionString));
adapter.UpdateCommand = new SqlCommand("", new SqlConnection(SqlHelper.ConnectionString));
adapter.SelectCommand = new SqlCommand(sqlstr, new SqlConnection(SqlHelper.ConnectionString));