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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.