Look at the Convert class it has a methods to convert to and from
loads of types. Check the Convert.ToString() convert method. Not
100% it will do the trick but it should.
>
>I was trying to do a little dot net proj to list all sp's and their
>definitions:
>
> sProcName = CStr(lstSP.Items.Item(lCount))
> cmd = New SqlCommand("sp_HelpText", cn)
> cmd.CommandType = CommandType.StoredProcedure
> cmd.Parameters.Add("@objname", sProcName)
> dr = cmd.ExecuteReader
> If dr.Read Then
> sCreate = ""
> iPosnText = dr.GetOrdinal("Text")
> Do
> sLine = CStr(dr.GetSqlString(iPosnName).Value)
> sCreate = String.Concat(sCreate, sLine)
> Loop Until Not dr.Read
> lblSP.Text = sAlter
> lblSP.Refresh()
> Write(iFileHandle, sCreate)
> End If
> dr.Close()
>
>what happens is that text is nvarchar
>
>i get back where [] is an undisplayable char
>
>"[] create procedure ...
>
>this seems to me to be a unicode string?
>how to I get it into a text string? - I've tried .tostring, cstr()
>
>please (oh and please dont retire the list)
>
>Many thanks
>
>Ian
>
>You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
>subscribe to other DevelopMentor lists at http://discuss.develop.com.
You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.
