刚接触c#,非常简单的问题!谢谢大家!

[lbeast]

// Create a new Connection and SqlDataAdapter

SqlConnection myConnection = new SqlConnection("server=(local)\\NetSDK;Trusted_Connection=yes;database=northwind");
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter("Select * from Region", myConnection);
SqlParameter workParam = null;


// Build the insert Command
mySqlDataAdapter.InsertCommand = new SqlCommand("Insert into Region (RegionID, RegionDescription) VALUES (@RegionID, @RegionDescription)", myConnection);

workParam = mySqlDataAdapter.InsertCommand.Parameters.Add("@RegionID", SqlDbType.Int);
workParam.SourceColumn = "RegionID";
workParam.SourceVersion = DataRowVersion.Current;

workParam = mySqlDataAdapter.InsertCommand.Parameters.Add("@RegionDescription", SqlDbType.NChar, 50);
workParam.SourceVersion = DataRowVersion.Current;
workParam.SourceColumn = "RegionDescription";

// Build the update command
mySqlDataAdapter.UpdateCommand = new SqlCommand("Update Region Set RegionDescription = @RegionDescription WHERE RegionID = @RegionID" , myConnection);

workParam = mySqlDataAdapter.UpdateCommand.Parameters.Add("@RegionID", SqlDbType.Int);
workParam.SourceColumn = "RegionID";
workParam.SourceVersion = DataRowVersion.Original;

workParam = mySqlDataAdapter.UpdateCommand.Parameters.Add("@RegionDescription", SqlDbType.NChar, 50);
workParam.SourceVersion = DataRowVersion.Current;
workParam.SourceColumn = "RegionDescription";

DataSet myDataSet = new DataSet();

// Set the MissingSchemaAction property to AddWithKey because Fill will not cause primary key & unique key information to be retrieved unless AddWithKey is specified.
mySqlDataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
mySqlDataAdapter.Fill(myDataSet, "Region");

DataRow myDataRow1 = myDataSet.Tables["Region"].Rows.Find(2);
myDataRow1[1] = "已更改此地区说明";

//********myDataRow1[1] = "已更改此地区说明";是什么意思???????*************

DataRow myDataRow2 = myDataSet.Tables["Region"].NewRow();
myDataRow2[0] = 901;
myDataRow2[1] = "新地区";
myDataSet.Tables["Region"].Rows.Add(myDataRow2);

try
{
mySqlDataAdapter.Update(myDataSet, "Region");
Console.Write("已成功更新数据集！");
}
catch(Exception e)
{
Console.Write(e.ToString());
}


问题见上面的注释.谢谢!

[pgy8288]

好长好乱的代码呀

[pgy8288]

更新dataset么

[lbeast]

不是我的 微软快速入门上的啊.

[Eddie005]

DataRow myDataRow1 = myDataSet.Tables["Region"].Rows.Find(2);//从记录集中找到主键为2的行
myDataRow1[1] = "已更改此地区说明";//给这一行记录的第2个字段赋值（即修改原来的值）
至于“已更改此地区说明”只是一个字符串，没有任何意义，也可以修改成“—（*……#·！%”

[yf1025]

注释？很多啊
//********myDataRow1[1] = "已更改此地区说明";是什么意思???????*************
把"更改此地区说明"付给 索引位1的myDataRow1数组