ADO.NET数据更新方法(2)

/// <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); 
} 
}