SqlCommand.Parameters

  • Thread starter Thread starter Brian Toothill
  • Start date Start date
B

Brian Toothill

I'm setting SqlDataAdapter.UpdateCommand (.CommandText and .Parameters).
Say the table to which I'm applying this command has a lot of columns - does
that mean I have to add a parameter (.UpdateCommand.Parameters.Add()) for
every column that I want to update (or every column that may potentially
change)?

On the same note, does that mean I have to add (to CommandText) something
simliar to "columnN = @colN" for every column?

So if my table has 50 columns, then my UpdateCommand will have 50
Parameters?

Am I asking the right questions / going about this the 'done' way?
 
Yup, you are correct.
You might use data wizard to create the adapter and commands for you..
 
You must log in or register to reply here.

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
using command to pass old and new values 2
Insert Commands SQL Server 2
sqladapter question 1
Error: ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'FillMenusByLocation 6
Strange error message 1
Help inserting specific value into an identity column 7
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1

Back
Top