//本节是关于使用dataSet做update
//基本操作很简单
//把需要修改的纪录调入到dataSet中
//用dataRow.BeginEdit()对其进行修改
//EndEdit之后dbAdapter.Update()
public String doUpdate(String strTableName, Hashtable hstParaTable, String strTableKey)
{
//strTableName: the name of the table
//hstParaTable: the hashtable containing the columnname-value pairs
//strTableKey: the name of the primary key column
String strConnection = System.Configuration.ConfigurationManager.AppSettings["SQLConnectionString"];
dbConnection = new SqlConnection(strConnection);
dataSet = new DataSet();
dbConnection.Open();
String sql = "SELECT * FROM " + strTableName.ToString() + " WHERE " + strTableKey.ToString() + " = " + hstParaTable[strTableKey.ToString()].ToString();
dbConnection = new SqlConnection(strConnection);
dataSet = new DataSet();
dbConnection.Open();
String sql = "SELECT * FROM " + strTableName.ToString() + " WHERE " + strTableKey.ToString() + " = " + hstParaTable[strTableKey.ToString()].ToString();
//仍然是在使用老伎俩 估计随便写个SQL也能用 没试过
dbAdapter = new SqlDataAdapter(sql, dbConnection);
dbAdapter.Fill(dataSet, strTableName.ToString());
dbAdapter.Fill(dataSet, strTableName.ToString());
dbConnection.Close();
DataTable myDataTable = dataSet.Tables[strTableName.ToString()];
DataRow myDataRow;
myDataRow = myDataTable.Rows[0];
//真正开始编辑update的内容是在这里
myDataRow.BeginEdit();
DataColumnCollection myDCC = myDataTable.Columns;
for (int i = 0; i < hstParaTable.Count; i++)
{
myDataRow[i] = hstParaTable[myDCC[i].ColumnName.ToString()];
DataColumnCollection myDCC = myDataTable.Columns;
for (int i = 0; i < hstParaTable.Count; i++)
{
myDataRow[i] = hstParaTable[myDCC[i].ColumnName.ToString()];
//将传递过来的hashTable的内容按项添加进去 column名作索引 不用担心顺序
}
myDataRow.EndEdit();
myDataRow.EndEdit();
String result = dbAdapter.Update(dataSet, strTableName.ToString()).ToString();
return "-" + result.ToString();
return "-" + result.ToString();
}