DataAdapter.Update鐨勭敤娉曪紵

[rainningsky]

DataAdapter.Update锛坉sName,tblName)涓嶥ataAdapter.Update锛坉sName)鐢ㄦ硶鏈変綍鍖哄埆锛熶负浠€涔堟垜鐨勬暟鎹泦涓彧鏈変竴涓〃鐢ㄥ悗闈㈢殑鏂规硶浼氬嚭閿欏憖锛熷涓嬮潰鐨勪唬鐮侊紝鎻愮ず鎵句笉鍒版槧灏勬垨琛ㄥ悕锛岃繖鍙槸寰蒋鐨勭ず渚嬩唬鐮佸憖锛佷絾鐢ㄥ墠涓€涓柟娉曞氨娌￠棶棰橈紝鐧炬€濅笉寰楀叾瑙ｏ紝杩樿澶ц櫨鎸囩偣涓€涓? SqlDataAdapter catDA = new SqlDataAdapter("SELECT CategoryID, CategoryName FROM Categories", nwindConn);

catDA.UpdateCommand = new SqlCommand("UPDATE Categories SET CategoryName = @CategoryName " +
"WHERE CategoryID = @CategoryID" , nwindConn);

catDA.UpdateCommand.Parameters.Add("@CategoryName", SqlDbType.NVarChar, 15, "CategoryName");

SqlParameter workParm = catDA.UpdateCommand.Parameters.Add("@CategoryID", SqlDbType.Int);
workParm.SourceColumn = "CategoryID";
workParm.SourceVersion = DataRowVersion.Original;

DataSet catDS = new DataSet();
catDA.Fill(catDS, "Categories");

DataRow cRow = catDS.Tables["Categories"].Rows[0];
cRow["CategoryName"] = "New Category";

catDA.Update(catDS);

[me121121]

什么字这么NB?

[笨笨兔兔兔兔兔]

DataAdapter.Update（dsName,tblName)与DataAdapter.Update（dsName)用法有何区别？为什么我的数据集中只有一个表用后面的方法会出错呀？如下面的代码，提示找不到映射或表名，这可是微软的示例代码呀！但用前一个方法就没问题，百思不得其解，还请大虾指点一丿 SqlDataAdapter catDA = new SqlDataAdapter("SELECT CategoryID, CategoryName FROM Categories", nwindConn); catDA.UpdateCommand = new SqlCommand("UPDATE Categories SET CategoryName = @CategoryName " + "WHERE CategoryID = @CategoryID" , nwindConn); catDA.UpdateCommand.Parameters.Add("@CategoryName", SqlDbType.NVarChar, 15, "CategoryName"); SqlParameter workParm = catDA.UpdateCommand.Parameters.Add("@CategoryID", SqlDbType.Int); workParm.SourceColumn = "CategoryID"; workParm.SourceVersion = DataRowVersion.Original; DataSet catDS = new DataSet(); catDA.Fill(catDS, "Categories"); DataRow cRow = catDS.Tables["Categories"].Rows[0]; cRow["CategoryName"] = "New Category"; catDA.Update(catDS);