English 中文(简体)
C# ASP.NET 1. 更新数据库
原标题:C# ASP.NET Update database with datatable

设想: 我只想更新我的数据库,介绍用户对其信息所作的改动。 我的守则是:

SqlCommandBuilder cb = new SqlCommandBuilder(da);

dt.Rows[0][2] = txtname.Text;
dt.Rows[0][3] = txtinterests.Text;
dt.Rows[0][4] = txtlocation.Text;

da.SelectCommand = new SqlCommand(sqlcommand, conn);
da.Update(dt);

我知道它会是显而易见的,但我错了什么? 没有任何错误,所有文件都正确汇编,但没有发生。 本记录可以更正。

最佳回答

你们需要界定数据检索的“最新信息”概念(可能的话,还包括“通信”)。

For each Modified row in the datatable, it will fire the command you specify as the UpdateCommand.
For each New row in the datatable, it will fire the command you specify as the InsertCommand.

查阅。 页: 1

问题回答

暂无回答




相关问题
Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

How to Add script codes before the </body> tag ASP.NET

Heres the problem, In Masterpage, the google analytics code were pasted before the end of body tag. In ASPX page, I need to generate a script (google addItem tracker) using codebehind ClientScript ...

Transaction handling with TransactionScope

I am implementing Transaction using TransactionScope with the help this MSDN article http://msdn.microsoft.com/en-us/library/system.transactions.transactionscope.aspx I just want to confirm that is ...

System.Web.Mvc.Controller Initialize

i have the following base controller... public class BaseController : Controller { protected override void Initialize(System.Web.Routing.RequestContext requestContext) { if (...

Microsoft.Contracts namespace

For what it is necessary Microsoft.Contracts namespace in asp.net? I mean, in what cases I could write using Microsoft.Contracts;?

Separator line in ASP.NET

I d like to add a simple separator line in an aspx web form. Does anyone know how? It sounds easy enough, but still I can t manage to find how to do it.. 10x!

热门标签