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
php/xmlrpc class issue
I am working on xml-rpc in php to start with.
I have a class that only has variables defined
rand() function
just a general question guys a girls, is the rand() function 100% random or is it based on time?
Passing Variables
What I'm wanting to do is when the user clicks on Arenas it will know the name of the country it's w
want to add a break after a certain amount of characters
i was wondering how to add a break in a blog post after a certain amount of characters... any idea o
Javascript form submit and radio buttons?
When this form is submitted, it is automatically resubmitted using JS.
All my fields are carr
if else problem, help please
i have this script that i made only i try to also put in a if else for for some reason the script is
TinyMCE / Ajax Postback Problem
Hiya all,
I have a page which loads the TinyMCE editor. On the postback I obviously want to f
Random date selection
i want to select random date with time(hour+minutes+sec) where date is specified(10/22/2009) and tim
"SEO" URLs
Hey, I'm wondering how to go about creating and using these types of URLs. I'm presuming it's PHP th
show the direct link into href
I want to display link on the page. i am fetching the data(URL) from database,actually before that i
