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...
 
Back
Top