Thanx Cerebrus. Actually I need to check them in DB ... I mean in Stored Procedure not in C#. I think, checking of parametr's data type in db is wrong approach and I never did it but I need to do now as it is our client's requirement. Client wants every check in DB.
On Wed, Apr 1, 2009 at 12:29 AM, Cerebrus <[email protected]> wrote: > > Use SqlParameters with the DbType set either via constructor or by > setting the property. > > On Mar 31, 10:53 pm, Aman Sharma <[email protected]> wrote: > > Hi, > > > > *MS SqlServer2005 - Stored Procedure* > > > > Is it possible to check for Invalid Data Type in SP? For eg:- String is > > passed into SP rather Integer. >
