Generating an SqlParameter from a value in a DataSet

microsoft.public.dotnet.framework.adonet

31 Jan 2006 5:00 PM

Stephan Zaubzer

How can I generate a Parameter if I cannot retrieve the SqlDbType from
an item in a row of a DataSet?
Is it safe to just take the object I retrieve from the DataSet and take
the following constructor for the Parameter:
SqlParameter(string parameterName, object value)???
Regards
Stephan

31 Jan 2006 5:51 PM

W.G. Ryan - MVP

Yep, that's 'safe'
Show quote

"Stephan Zaubzer" <stephan.zaub***@schendl.at> wrote in message
news:eoVrRfoJGHA.3944@tk2msftngp13.phx.gbl...
> How can I generate a Parameter if I cannot retrieve the SqlDbType from an
> item in a row of a DataSet?
> Is it safe to just take the object I retrieve from the DataSet and take
> the following constructor for the Parameter:
> SqlParameter(string parameterName, object value)???
> Regards
> Stephan