question

[Guest]

how to test the input parameter of stored procedure
whether is string or int

 

[Guest]

Try looking at regular expressions. This link should help :
http://www.c-sharpcorner.com/3/RegExpPSD.asp

 

[Jason Hales]

Are you using SqlCommandBuilder.DeriveParameters(command) to get the
parameters for a stored proc that you don nto knwo about at runtime?
If so you could try this:

SqlCommand command = new SqlCommand("MyStoredProc", connection);
command.CommandType = CommandType.StoredProcedure;
SqlCommandBuilder.DeriveParameters(command);

bool isString;

DbType paramType = command.Parameters[1].DbType;
if (paramType == DbType.AnsiString ||
paramType == DbType.AnsiStringFixedLength ||
paramType == DbType.String ||
paramType == DbType.StringFixedLength)
{
isString = true;
}
else
{
isString = false;
}