Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OleDBDataAdapter.Update
Message
From
02/03/2005 09:42:43
 
 
To
02/03/2005 08:13:41
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00991026
Message ID:
00991955
Views:
15
>Thank you so much, Bonnie<

No problem. You're welcome, Grig. =)

>Eventually, that's what I did. Unfortunatelly, when customer saw half of his application needs to be thrown away said "ok, i was hoping we'll fix it doing small changes here and there, but it looks in not possible, that's why we'll stop".<

Why would half his application need to be thrown out? Do you mean that the stuff you had to change was "all or nothing", rather than a little here and there?

~~Bonnie



>
>:) Thank you anyway,
>Grig.
>
>>Hey Grig,
>>
>>>I didn't design the application and there is no table. <
>>
>>No table? Odd. Then why did you have a table in your .Update() statement? Well, never mind, the solution is simple. Don't use .Update(), don't even use the DataAdapter. Try this (untested code, watch for typos):
>>
>>OleDbCommand command = new OleDbCommand("Insert into table (field1, field2) Values (@par1, @par2)", MyConnection);
>>command.Parameters.Add("@par1","value1")
>>command.Parameters.Add("@par2","value2")
>>command.ExecuteNonQuery();
>>
>>
>>~~Bonnie
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Reply
Map
View

Click here to load this message in the networking platform