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

Optimize Code
Just started getting into the use of cookies. The following code will redirect users to a set URL s

Issues: PHP Forms -Clearing
I've tried looking online before actually asking for help, but I've been looking for about the past

Content-Disposition: attachment; filename=... not working as i thought it should
taken the following code from the php.net site the script is not working.

what is not happeni

Checking if field is empty AND using !is_numeric
Hi lads,

Need to be able to display an error message (using isset?) that says "Cant lea

upload only text files
hi guys i want to upload only text like like (pdf,note pad and ofiice files) so can any one please t

Filling gaps in dates
So i'm doing a query for sales data and my return array looks like this

('date' => '20

generating random codes
Hi guys n gals,

I have a requirement to generate 250,000 unique codes...

These codes a

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

Limiting uploaded file type
I am working on a simple upload script, and I need it to limit the allowed file type that is uploade

updating a single value to multiple non consecutive rows
I need to update the same value to multiple non consecutive rows. I need to add an experation date t