Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
OleDBDataAdapter.Update
Message
De
02/03/2005 09:42:43
 
 
À
02/03/2005 08:13:41
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Divers
Thread ID:
00991026
Message ID:
00991955
Vues:
14
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform