Member Avatar for jozcar@yahoo.co

command.Parameters.Add("@BrandName", SqlDbType.VarChar);
command.Parameters.Add("@BrandName", SqlDbType.VarChar,50);


The above are two possible ways to add a parameter on SqlCommand, is there any benefit on specifying the value 50.

  • 2 Contributors
  • 2 Replies
  • 79 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by jozcar@yahoo.co
Member Avatar for Ramy Mahrous

I don't know but it may trim the string before executing DML statement, it sure better than doing such via SQL engine. Jusing guessing good question (Y)
And it may have no effect

Member Avatar for jozcar@yahoo.co

well, this has being bugging me for a while, tanks for the reply

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.