用SqlDataAdapter.update(),不过SqlDateAdapter要写UpdateCommand的Update语句.具体的可以看帮助文档
解决方案 »
- ASP.NET如何做两个数据库表的对比
- 【新手问题】怎么把主函数main()中定义的变量传递去窗体form1.cs的函数体去
- c#中引用Excel为什么只有office.core而出不来office.interop啊
- C#,循环的问题 第三贴,有更详细的说明
- 如何让自定义event在 属性浏览器中显示出来?
- 群组权限设定的问题?
- 怎么取得运行中的程序的安装绝对路径?
- 前两天发的100分帖子没人答复沉了今天在来送50,给答案者多给,回复有分。
- 做了一个判断时间的程序,然后时间跳到第二天,我就笑了!!!求思路啊,求方法啊!!!
- 如何输入回车?
- DataGrid的中查找某行的问题,开第二贴再问!!!
- 怎么读取USB口数据
SqlDataAdapter SqlDa = new SqlDataAdapter(strSel,myconn);
SqlCommandBuilder SqlCd = new SqlCommandBuilder(SqlDa);
SqlDa.Update(ds,"table");
已生成SELECT语句
已生成INSERT语句
......等
这样你就可以在代码里面加入
da.update(dataset,"table");
这样就能更新了
{
oracleConnection1.Open();
System.Data.OracleClient.OracleDataAdapter ora_adp = new System.Data.OracleClient.OracleDataAdapter("select * from clientregiste",oracleConnection1);
new System.Data.OracleClient.OracleCommandBuilder(ora_adp);
DataSet dstobj = new DataSet();
ora_adp.Fill(dstobj,"originally");
System.Data.DataRow row = dstobj.Tables["originally"].Rows[1];
row.Delete();
dstobj.AcceptChanges();
ora_adp.Update(dstobj,"originally");
oracleConnection1.Close();
}
catch(Exception ora_err)
{
Label1.Text = ora_err.Message;
}
finally
{
oracleConnection1.Close();
}
大家看看这个写得有什么问题。我可真是没法了。
{
oracleConnection1.Open();
System.Data.OracleClient.OracleDataAdapter ora_adp = new System.Data.OracleClient.OracleDataAdapter("select * from clientregiste",oracleConnection1);
OracleCommandBuilder objCommandBuilder=
new System.Data.OracleClient.OracleCommandBuilder(ora_adp);
ora_adp .DeleteCommand = objCommandBuilder.GetDeleteCommand();
ora_adp .InsertCommand = objCommandBuilder.GetInsertCommand();//如果只是删除操作后更新,
此句和下面一句可以不要
ora_adp .UpdateCommand = objCommandBuilder.GetUpdateCommand();//DataSet dstobj = new DataSet();
ora_adp.Fill(dstobj,"originally");
System.Data.DataRow row = dstobj.Tables["originally"].Rows[1];
row.Delete();
dstobj.AcceptChanges();
ora_adp.Update(dstobj,"originally");
oracleConnection1.Close();
}
catch(Exception ora_err)
{
Label1.Text = ora_err.Message;
}
finally
{
oracleConnection1.Close();
}
--------------------------------------------------------------------------------Dynamic SQL generation for the DeleteCommand is not supported against a SelectCommand that does not return any key column information.
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.InvalidOperationException: Dynamic SQL generation for the DeleteCommand is not supported against a SelectCommand that does not return any key column information.源错误:
行 62: System.Data.OracleClient.OracleDataAdapter ora_adp = new System.Data.OracleClient.OracleDataAdapter("select * from clientregiste",oracleConnection1);
行 63: System.Data.OracleClient.OracleCommandBuilder objCommandBuilder = new System.Data.OracleClient.OracleCommandBuilder(ora_adp);
行 64: ora_adp .DeleteCommand = objCommandBuilder.GetDeleteCommand();
行 65: DataSet dstobj = new DataSet();
行 66: ora_adp.Fill(dstobj,"originally");
源文件: c:\inetpub\wwwroot\数据提交\webform1.aspx.cs 行: 64 堆栈跟踪:
[InvalidOperationException: Dynamic SQL generation for the DeleteCommand is not supported against a SelectCommand that does not return any key column information.]
System.Data.OracleClient.OracleCommandBuilder.BuildWhereClause(DataTableMapping mappings, DataRow dataRow, StringBuilder builder, IDbCommand command, Int32 parameterCount, Boolean isupdate) +790
System.Data.OracleClient.OracleCommandBuilder.BuildDeleteCommand(DataTableMapping mappings, DataRow dataRow) +91
System.Data.OracleClient.OracleCommandBuilder.base_GetDeleteCommand() +27
System.Data.OracleClient.OracleCommandBuilder.GetDeleteCommand() +5
数据提交.WebForm1.Button1_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\数据提交\webform1.aspx.cs:64
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277
--------------------------------------------------------------------------------
版本信息: Microsoft .NET Framework 版本:1.1.4322.573; ASP.NET 版本:1.1.4322.573