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
Check premium expire
Hi,
I am making a simple file hosting site and want to check if users premium subscriptions h
How To Make More Than One Redirection with PHP on the same page?
Hey im trying to do a direction page where it open differently link direction pages every time som
difference between datetimes
($row['totime']-$row['fromtime'])/60
this is giving me 0
example of totime and fromtim
Frustrated php Newbie
First off, I am pretty much a PHP nub. I can read and understand the language (most of the time) so
mysql_real_escape_string
Let me preface this that I am very much a PHP noob, but I have some SQL training (not necessarily My
building a function with multiple outputs
I want to build a function that has multiple outputs.
I know but am not to sure how I should
Parse Error with doctype
I'm getting a parse error with this simple code. I don't get it. It worked one time then when I relo
Auto install
Hi I have a directory lets say "apps" that I then have more folders ie "email",
Table sorting
Hi,
I'm trying to modify the following in order to make the output table sorted alphabeticall
How to write on database when a link is clicked?
Hi,
I have a list of products in a gridview. When the link is clicked currently it takes to an ext
