i am sending parameters to sql server 2008's store procedure
but confuse that which way to send parameters mean we got 2 ways , parameters.add(parameter)
and 2nd way, parameters.add("@parameter",sqldbtype.datatype).value= value

so which one to use and y ?

priyanshu.net commented: Very Nice +0

ok done , parameters.add("@parameter",sqldbtype.datatype).value= value
is preffered to use, bcz it provide type casting

Be a part of the DaniWeb community

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