在线等候，Managed C++操作SQL Server数据库

[yuanyingtanxi]

String *sql=String::Format(S"SELECT * FROM user_tb WHERE id={0}",UserID);
SqlDataAdapter *adapter = new SqlDataAdapter();
SqlCommand *mycmd=new SqlCommand(sql,mySQLConnection);
adapter->SelectCommand = mycmd;
DataSet *dataset=new DataSet();
DataTable *dtab = new DataTable();
DataRow *dr;
adapter->Fill(dataset,"user_tb");
dtab=dataset->get_Tables()->get_Item(0);
dr = dtab->get_Rows()->get_Item(0);
dr->set_Item("UserName",UserName);
dr->set_Item("Password",UserPass);
....
adapter->Update(dataset,"user_tb");

[yuanyingtanxi]

错误提示在adapter->Update(dataset,"user_tb");这里，告诉我需要一个可更新的查询，何解？
再有，操作数据需要这么麻烦么，是不是有简单的方法。

[yuanyingtanxi]

不能用update语句，因为我的数据里面有备注类型，放在update语句里我怕太长了

[yuanyingtanxi]

VC.net人气低迷~~~~~~~~~~~~~
55555555555555

[hunyuan]

正在学.net,VC.net还没开始

[yuanyingtanxi]

后面几句改成这样
dr->BeginEdit();
dr->set_Item("UserName",UserName);
dr->set_Item("Password",UserPass);
....
dr->AcceptChanges();
SqlCommandBuilder *cb = new SqlCommandBuilder(myDataAdapter);
adapter->Update(dataset,"user_tb");
以后不出错了,可是数据也没有更新~~~~~~~~~~~~~~~~~~~
气死我了.
把程序改成同样的C#代码,也是这样的问题,就是不更新.
郁闷中....................

[yuanyingtanxi]

顶

[loepin]

没有用vb.net的吗？

[hunyuan]

试试
this->BindingContext->get_Item(dataset, S"user_tb")->EndCurrentEdit();

SqlCommandBuilder *cb = new SqlCommandBuilder(adapter);
adapter->Update(dataset,"user_tb");

[yuanyingtanxi]

提