企业库更新强类型DATASET所遇到的问题！

[C2K]

更新代码如下：
SqlDatabase db = new SqlDatabase(this.myConfig.GetConnectionStringByDatabaseName(ApplicationConfiguration.UsingDatabaseName));

DbCommand newCommand = db.GetStoredProcCommand("NewDoc");
db.AddInParameter(newCommand, "GoodsID", SqlDbType.NVarChar, DataRowVersion.Current);
db.AddInParameter(newCommand, "GoodsCount", SqlDbType.Int, DataRowVersion.Current);
db.AddInParameter(newCommand, "aMoney", SqlDbType.Money, DataRowVersion.Current);
db.AddInParameter(newCommand, "DocID", SqlDbType.NVarChar, DataRowVersion.Current);

DbCommand deleteCommand = db.GetStoredProcCommand("DeleteDoc");
db.AddInParameter(deleteCommand, "IDs", SqlDbType.Int, DataRowVersion.Current);

DbCommand updateCommand = db.GetStoredProcCommand("UpdateDoc");
db.AddInParameter(updateCommand, "IDs", SqlDbType.Int, DataRowVersion.Current);
db.AddInParameter(updateCommand, "GoodsID", SqlDbType.NVarChar, DataRowVersion.Current);
db.AddInParameter(updateCommand, "GoodsCount", SqlDbType.Int, DataRowVersion.Current);
db.AddInParameter(updateCommand, "aMoney", SqlDbType.Money, DataRowVersion.Current);
db.AddInParameter(updateCommand, "DocID", SqlDbType.NVarChar, DataRowVersion.Current);

int rowsAffected = db.UpdateDataSet(refdsdetailIntoWHDoc, tableName, newCommand, updateCommand,
deleteCommand, UpdateBehavior.Standard);

return rowsAffected;



在SQL SERVER2005的表中看到的数据是这样的：

IDs GoodsID GoodsCount aMoney DocID
1 Current 512 512.00000 Current
2 Current 512 512.00000 Current
3 Current 512 512.00000 Current
4 Current 512 512.00000 Current
5 Current 512 512.00000 Current
6 Current 512 512.00000 Current





问一下，怎么都会这样的数据的？问题在哪里呢？谢谢！

[C2K]

顶一下,大家帮帮忙吧.

[C2K]

怎么都没人的呢

[C2K]

再顶一次就放弃了

[北京的雾霾天]

DataRowVersion.Current是表示状态,
而在楼主的代码中放在参数的位置实际上是值的位置,
而这个值的字符串形式是Current
数据的形式是512,
所以楼主存到数据库里的就会是这两个值了,而不是楼主想要的值.

[北京的雾霾天]

楼主参见下在的代码:
SqlDataAdapter dataAdpater = new SqlDataAdapter("SELECT CategoryID, CategoryName FROM Categories", connection);

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

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

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

DataSet dataSet = new DataSet();
dataAdpater.Fill(dataSet, "Categories");

DataRow row = dataSet.Tables["Categories"].Rows[0];
row ["CategoryName"] = "New Category";

dataAdpater.Update(dataSet, "Categories");

[C2K]

谢谢楼上的这位朋友!!!原来是这样的,现在明白了!