我自己弄一个表,字段Id(自增),myName(varhchar(50)),myAge(int) 记录: 1 Kaka 23
2 XianXian 24
下面是两个方法:
public int UpdateMy(Database db,DataSet myDs)
{ DbCommand insertCommand = db.GetStoredProcCommand("InsertRecord");
db.AddInParameter(insertCommand, "myName", DbType.String, "myName", DataRowVersion.Current);
db.AddInParameter(insertCommand, "myAge", DbType.Int32, "myAge", DataRowVersion.Current);
DbCommand delCommand = db.GetStoredProcCommand("DelRecord");
db.AddInParameter(delCommand, "Id", DbType.Int32, "Id", DataRowVersion.Current); DbCommand updateCommand = db.GetStoredProcCommand("UpdateRecord");
db.AddInParameter(updateCommand, "Id", DbType.Int32, "Id", DataRowVersion.Current);
db.AddInParameter(updateCommand,"myName",DbType.String,DataRowVersion.Current);
db.AddInParameter(updateCommand, "myAge", DbType.Int32, DataRowVersion.Current); int rowAffected=db.UpdateDataSet(myDs,"my",insertCommand,updateCommand,delCommand,UpdateBehavior.Standard);
return rowAffected; }//更新一个记录public void update_Record()
{ Database db = DatabaseFactory.CreateDatabase();
DataSet myDs = new DataSet();
string sqlCommand = "select * from my";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
string myTable = "my";
db.LoadDataSet(dbCommand, myDs, myTable);
DataTable table = myDs.Tables[myTable];
table.Rows[0]["myName"] = "ShuiShui";
this.UpdateMy(db,myDs); }
执行后统统是: 1 Current 512
2 XianXian 24
这是为什么,请高手给点指点 谢谢!!·!·!·
2 XianXian 24
下面是两个方法:
public int UpdateMy(Database db,DataSet myDs)
{ DbCommand insertCommand = db.GetStoredProcCommand("InsertRecord");
db.AddInParameter(insertCommand, "myName", DbType.String, "myName", DataRowVersion.Current);
db.AddInParameter(insertCommand, "myAge", DbType.Int32, "myAge", DataRowVersion.Current);
DbCommand delCommand = db.GetStoredProcCommand("DelRecord");
db.AddInParameter(delCommand, "Id", DbType.Int32, "Id", DataRowVersion.Current); DbCommand updateCommand = db.GetStoredProcCommand("UpdateRecord");
db.AddInParameter(updateCommand, "Id", DbType.Int32, "Id", DataRowVersion.Current);
db.AddInParameter(updateCommand,"myName",DbType.String,DataRowVersion.Current);
db.AddInParameter(updateCommand, "myAge", DbType.Int32, DataRowVersion.Current); int rowAffected=db.UpdateDataSet(myDs,"my",insertCommand,updateCommand,delCommand,UpdateBehavior.Standard);
return rowAffected; }//更新一个记录public void update_Record()
{ Database db = DatabaseFactory.CreateDatabase();
DataSet myDs = new DataSet();
string sqlCommand = "select * from my";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
string myTable = "my";
db.LoadDataSet(dbCommand, myDs, myTable);
DataTable table = myDs.Tables[myTable];
table.Rows[0]["myName"] = "ShuiShui";
this.UpdateMy(db,myDs); }
执行后统统是: 1 Current 512
2 XianXian 24
这是为什么,请高手给点指点 谢谢!!·!·!·
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货