很简单的问题，就是已经有数据的dataset怎么更新回数据库中，在线等，解决就给分。

[匿名用户12345]

我的代码如下所示，但总是更新不回去，提示DataAdapter.SelectCommand 属性需要初始化
我没做过这种，现在着急啊，有人知道怎么更新回去么？数据库已经为空，执行的是insert 操作，不是update操作。

DataSet Dataset = new DataSet();
OleDbConnection sqlCon = new OleDbConnection(strConnection);
OleDbCommand Command = new OleDbCommand("",sqlCon);
OleDbDataAdapter Adapter = new OleDbDataAdapter();
Command.CommandText = "delete from "+TableName;
sqlCon.Open();
Command.ExecuteNonQuery();
OleDbCommandBuilder cb = new OleDbCommandBuilder(Adapter);
Dataset.ReadXml(FilePath);
Adapter.Update(Dataset,TableName);

[itants]

Dim catDA As SqlDataAdapter = 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")

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

Dim catDS As DataSet = New DataSet
catDA.Fill(catDS, "Categories")

Dim cRow As DataRow = catDS.Tables("Categories").Rows(0)
cRow("CategoryName") = "New Category"

catDA.Update(catDS)
用update方法

[flyskywlh]

你少了一句,在Adapter.Update(Dataset,TableName);前

Adapter.UpdateCommand=cb.GetUpdateCommand();

[匿名用户12345]

加了也不行

[匿名用户12345]

自己解决了
Adapter.SelectCommand = new OleDbCommand("select * from "+TableName,sqlCon);
Adapter.InsertCommand = cb.GetInsertCommand();

[gu1dai]

感谢。

[Firestone2003]

恭喜

[昵称都被占完求了]

恭喜
接分

[claus2001]

mark