sqlAdapter.SelectCommand.Parameters.Add

  • Thread starter Thread starter Ondrej Sevecek
  • Start date Start date
O

Ondrej Sevecek

Is there neccessary to specify length of the parameter added, especially for
NVarChar parameters?
What will be the default behaviour, when the parameter length will not be
specified?

Ondra
 
why? Stored procedure will have the size specified itself. Are there some
drawbacks without using the size?

Ondra
 
that way, you are telling to .Net that you need to occupy specific
size of memory aread for the parameter. so, it helps to optimize the
things.

Rajesh Patel
 
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

DB type from user string input 2
ADO.NET 2.0 saving single space to SQL? 7
Re: Parameter size for NVARCHAR(MAX) data type? 0
sqldttype uniqueidentifier and stored procedure 4
TableAdapter.Update fails with missing parameter 8
SqlParameter.Size - When to use? 1
Parameter size for NVARCHAR(MAX) data type? 1
varchar(max) - SqlParameter 2

Back
Top