Problem with the Update command used with a sqldataadapter

Posted on 16th Feb 2014 07:03 pm by admin

I'm connected to a database on an SQL Server and I'm using a sqldataadapter, sqlconnection, sqldataset generated at DESIGNTIME.
I want to call the update command asociated with a sqldataadapter but I don't want to use all the parametres in the command becose I don't need to.
An sqlUpdateCommand created at DESIGNTIME look like this

this.sqlUpdateCommand1.CommandText = @"UPDATE masini SET producatoriID = @producatoriID, tip = @tip, combustibil = @combustibil, pret = @pret, [data achizitiei] = @Param2 WHERE (masiniID = @Original_masiniID) AND (combustibil = @Original_combustibil) AND ([data achizitiei] = @Original_data_achizitiei) AND (pret = @Original_pret) AND (producatoriID = @Original_producatoriID OR @Original_producatoriID IS NULL AND producatoriID IS NULL) AND (tip = @Original_tip); SELECT masiniID, producatoriID, tip, combustibil, pret, [data achizitiei] FROM masini WHERE (masiniID = @masiniID)";

Pls get me out of this mess.


And another thing. If you have some documentation on Crystal Reports (for SQL Server databases) please send me an e-mail with an attach file.

Your Answer:

Login to answer

Other forums

bit of help needed
Im about to sort out my registration page for my website by customising a "registration" s

LinkedList help
Ok so I just learned quickly about lists, so I have a not too hard project I think, but am having a

i want run some web server under the ip sharer
hello i want run some web server under the ip sharer
my ip is floating ip but it doesnt matter

how to put the 0-100 numbers into 1.txt and 100-200 into 2.txt ?
how to put the 0-100 numbers into 1.txt and 100-200 into 2.txt and so on 200-300 into file 3.txt ?

Problem with passing variables
I'm not really a php programmer so I'm really struggling with this issue.

I have a banner s

present value of sequence?
Hi

Please help me to find out the present value of sequence?

Thanks

PHP Error
On my .php page I have a drop down box that has several names in it. When a user clicks the name &am

Oracle Connectivity
Hi Every One,

Can we access SAP from oracle database.If it possible then please spec

Why is the logic of this simple code not working?
Hey, I'm trying to determine if a table already exists in mysql, but doing a query first with mysql_

with clause
hi all, i have a big query that usually access the same table more than once. for example, i have s