/// <summary>
/// ADO.NET数据更新方法(2)
/// 适用范围:单表、有主键、不能更新图象列
/// </summary>
public DataSet UpdateByDataSet(DataSet ds,string tableName, string connectionString)
{
SqlConnection conn = new SqlConnection(connectionString));
string sql = "select * from " + tableName;
SqlCommand myCommand = new SqlCommand(sql),(SqlConnection) conn);
SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand );
SqlCommandBuilder myCommandBuilder = new SqlCommandBuilder(myAdapter);
myAdapter.InsertCommand = myCommandBuilder .GetInsertCommand();
myAdapter.UpdateCommand = myCommandBuilder .GetUpdateCommand();
myAdapter.DeleteCommand = myCommandBuilder .GetDeleteCommand();
try
{
conn.Open();
myAdapter.Update(ds,tableName);
conn.Close();
return ds;
}
catch(Exception err)
{
conn.Close();
throw new BusinessException(err);
}
}
/// ADO.NET数据更新方法(2)
/// 适用范围:单表、有主键、不能更新图象列
/// </summary>
public DataSet UpdateByDataSet(DataSet ds,string tableName, string connectionString)
{
SqlConnection conn = new SqlConnection(connectionString));
string sql = "select * from " + tableName;
SqlCommand myCommand = new SqlCommand(sql),(SqlConnection) conn);
SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand );
SqlCommandBuilder myCommandBuilder = new SqlCommandBuilder(myAdapter);
myAdapter.InsertCommand = myCommandBuilder .GetInsertCommand();
myAdapter.UpdateCommand = myCommandBuilder .GetUpdateCommand();
myAdapter.DeleteCommand = myCommandBuilder .GetDeleteCommand();
try
{
conn.Open();
myAdapter.Update(ds,tableName);
conn.Close();
return ds;
}
catch(Exception err)
{
conn.Close();
throw new BusinessException(err);
}
}