PC Review


Reply
Thread Tools Rate Thread

Confusion with DeleteCommand, and UpdateCommand

 
 
Arsalan
Guest
Posts: n/a
 
      8th Feb 2005
How do I use DeleteCommand, and UpdateCommand, the SQL string in them is
really confusing with bunch of parameters, what are the parameters order ?
Can I make customized DeleteCommand [which calls Update SQL statement]?


 
Reply With Quote
 
 
 
 
Sahil Malik
Guest
Posts: n/a
 
      8th Feb 2005
The command itself is really simple. It is simply a SQL Text. The parameters
are for reuse and flexibility, they are not confusing as you simply assign a
value to them. Thats it. The parameter order is the same as that mentioned
in your commandtext

> Can I make customized DeleteCommand [which calls Update SQL statement]?

Yes, but that would be incorrect logic. It will update rows when you had
expected to delete them.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/




"Arsalan" <(E-Mail Removed)> wrote in message
news:O3%(E-Mail Removed)...
> How do I use DeleteCommand, and UpdateCommand, the SQL string in them is
> really confusing with bunch of parameters, what are the parameters order ?
> Can I make customized DeleteCommand [which calls Update SQL statement]?
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: DeleteCommand Herfried K. Wagner [MVP] Microsoft VB .NET 0 17th Sep 2005 10:03 PM
DataGrid.DeleteCommand Duane Leem, BSIT Microsoft C# .NET 2 12th Feb 2004 07:58 PM
InsertCommand, UpdateCommand, DeleteCommand Sébastien Microsoft ADO .NET 0 12th Feb 2004 04:16 PM
DataAdapter problem (UpdateCommand, DeleteCommand) Sébastien Microsoft ADO .NET 4 28th Jan 2004 08:03 AM
How to use InsertCommand,UpdateCommand,DeleteCommand Bharat Microsoft ADO .NET 2 20th Oct 2003 08:10 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:15 AM.