Dynamic cast string value to a specific data type for stored procedure

[tedqn]

Problem:
- Stored procedure input parameters data type specific (SqlDbType.Int,
SqlDbType.VarCh ar,etc).
- Form submitted value in TextBox, DropDownList, etc are all string
type (I guess). Some maybe empty.

I need a function that would grab the string value and dynamically
convert to the corresponding data type specific sql parameter OR
DBNull.Value. The problem is that I have to specifically specify what
data type the function will return. I don't want to do an if for every
single parameter ..

if(DateEnd.Valu e != "") {
myCommand.Param eters.Add("@str DateEnd",
SqlDbType.VarCh ar).Value =
Convert.ToDateT ime(DateEnd.Val ue); ;
}
else {
myCommand.Param eters.Add("@str DateEnd",
SqlDbType.VarCh ar).Value = DBNull.Value;
}

[Robbe Morris [C# MVP]]

The link to the ado.net source generator does this. Take
the code out of it.

--
Robbe Morris - 2004-2006 Microsoft MVP C#
I've mapped the database to .NET class properties and methods to
implement an multi-layered object oriented environment for your
data access layer. Thus, you should rarely ever have to type the words
SqlCommand, SqlDataAdapter, or SqlConnection again.
http://www.eggheadcafe.com/articles/..._generator.asp

<te***@yahoo.co mwrote in message
news:11******** **************@ i3g2000cwc.goog legroups.com...

Problem:
- Stored procedure input parameters data type specific (SqlDbType.Int,
SqlDbType.VarCh ar,etc).
- Form submitted value in TextBox, DropDownList, etc are all string
type (I guess). Some maybe empty.

I need a function that would grab the string value and dynamically
convert to the corresponding data type specific sql parameter OR
DBNull.Value. The problem is that I have to specifically specify what
data type the function will return. I don't want to do an if for every
single parameter ..

if(DateEnd.Valu e != "") {
myCommand.Param eters.Add("@str DateEnd",
SqlDbType.VarCh ar).Value =
Convert.ToDateT ime(DateEnd.Val ue); ;
}
else {
myCommand.Param eters.Add("@str DateEnd",
SqlDbType.VarCh ar).Value = DBNull.Value;
}