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
Comparing two dates
Hi Guys
I have two dates I want to compare. Below is my current implementation. The problem with
Move array index to end
Hey guys,
Quick question:
I have an array that looks like this:
Code: [Select]$var =
Update Myspace status with CURL
Logging in:
Code: <?php
class Myspace
{
function login($username, $pa
Check Date/Time in PHP
What I need the code to check is that $reQuest is 24 hours in the past then return a time based on h
Show message after entering data
Hello Colleagues
I would like to display messages after entering the data example: "
dat
The page should be expire when cilck back button
hi,
i'm new to php world.
i create user registration page.
when i submit it,data goes to my
Connecion issue
Hi,
For some reason, I keep getting this error when trying to connect:
Warning: mysql_
Error: SQL Syntax; Line 1
Code:
<?php require "global_settings.php"; ?>
<title&g
Word Trimming
Hi Guys & Gals!!
Hope you are all ok....
I need some help with the followingOutput Full URL of Current Page
Let's say I am currently viewing a dynamic page:
http://www.mydomain.com/directory/index.php
