Confusion with DeleteCommand, and UpdateCommand

  • Thread starter Thread starter Arsalan
  • Start date Start date
A

Arsalan

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]?
 
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]?
Click to expand...
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 said:
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]?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Class with oledbcommand problem 5
DAAB - Enterprise Library 3
How can I use InsertCommand, UpdateCommand? 3
ADO.NET - Problem with Insert-, Delete- and UpdateCommand 3
How to use InsertCommand,UpdateCommand,DeleteCommand 2
get @RETURN_VALUE after calling MyTableAdapter.Update(...) 1
DataAdapter using commandbuilder's commands, not it's own. 1
dataAdapter'rs command statements 2

Back
Top