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
Did you know?Explore Trending and Topic pages for more stories 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.
No comments posted yet
Your Answer:
Login to answer
134 
53 
Other forums
Wierd if else problem
Hi guys,
this probably aint wierd for you, but it seems like php is playin up to me. may b i
Sendmail.php - heading error following check_input
Hi,
I would greatly appreciate some help? I am brand new to PHP and have been searching and e
Is there a function ... auto send IP
Is there some function that can be sent to a ddns service that returns the ip address of a ddns forw
max function question
Hi All
Ihave a table that holds shipment numbers and dates like this
select * from
how to easy edit text, with box? Help.
Hi.
I have a little problem. I'm doing a webpage for my aunt and I would like to make it as easy
parse error
On my local machine I keep getting parse error for my footer. When I put it online, it doesn't show
present value of sequence?
Hi
Please help me to find out the present value of sequence?
Thanks
Need help making login verification cleaner...
I use the below to verify user login. I first check the cookie for the id, ip and a unique id. If it
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
article site help remaining text
Hi all hope you will be fine
I am creating a article site in this site i want to put some text on
