function to build sql update string based upon data type

[TJS]

looking for generic function to build sql update string for values coming
from a form.
I've seen these for classic asp but I'm not finding equivalent in asp.net

Googleing did not help so far

 

[Steve C. Orr [MVP, MCSD]]

Perhaps the easiest way is by using Microsoft's free Data Application Block.
Here's more info:
http://www.devx.com/codemag/Article/22641

 

[Curt_C [MVP]]

what part is the issue? You should be able to do it the same way really.....

 

[TJS]

I want to do something like this but don't know how .net gets the datatype
or which type of database connection to use for updating field


======================

strName = vFldname
intType = Cint(objRS(vFldname).Type)
strNewValue = vFldValue

If strName <> "ID" Then 'skip primary key
Select Case intType
Case 2, 3, 4, 5, 6, 17 'number fields
If not IsNumeric(strNewValue) Then strNewValue = Null
Case 11 'yes/no fields
If UCase(strNewValue) = "ON" Then
strNewValue = 1
Else
strNewValue = 0
End If
Case 7,135 'date/time fields
If not IsDate(strNewValue) Then strNewValue = Null
Case Else 'string fields
If Trim(strNewValue) & "" = "" Then strNewValue = Null
End Select

strNewValue = dataPrep(strNewValue)
objRS(strName) = strNewValue

End If