cmd.Parameters.Add (P);</pre>The constructor for SqlParameter is documented as infering the type when you use the signature that accepts the name and value. This may be failing somehow and causing a ...

Peter revisits an earlier tip on how to use stored procedures to speed up your code. This version makes your stored procedures simpler … though you may have to write a little more code to make the ...

I'm trying to figure out how to use the SQL where/in syntax with a paramterized query. For instance let's say I'd like to run the following query: select * from customers where custid in (1,2,3); I ...