C#使用DataSet之Update

//本节是关于使用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();

       //仍然是在使用老伎俩 估计随便写个SQL也能用 没试过

      

        dbAdapter = new SqlDataAdapter(sql, dbConnection);
        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()];

        //将传递过来的hashTable的内容按项添加进去 column名作索引 不用担心顺序

 

        }
        myDataRow.EndEdit();

 

 

 

        String result = dbAdapter.Update(dataSet, strTableName.ToString()).ToString();
        return "-" + result.ToString();

 

    }