Command Parameters

  • Thread starter Thread starter Jim Heavey
  • Start date Start date
J

Jim Heavey

When calling a stored procedure and building the SqlParameter object, Is it
required to specify the data type of the parameter (String, Integer, etc.)?
When would in not be required?
 
No, it is not required. The command will take a look at the type of the
value and use that for the dbtype. It actually does a nice job doing this,
so technically you only need to pass the param name and value. I would
recommend, if you can, passing the type and size though.
 
Thanks
Greg said:
No, it is not required. The command will take a look at the type of the
value and use that for the dbtype. It actually does a nice job doing this,
so technically you only need to pass the param name and value. I would
recommend, if you can, passing the type and size though.
Click to expand...
 
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

Reusing parameters 2
Re: Parameter size for NVARCHAR(MAX) data type? 0
Dynamically Populating a SqlParameter object 5
SqlParameter.Size - When to use? 1
Calling a stored procedure with a output parameter 1
SqlCommandBuilder DeriveParameters Ouput Arg gets wrong direction 1
varchar(max) - SqlParameter 2
insert stored procedure does not commit to the database More options 4

Back
Top