CODEWITHSUNDEEP
asp.netvb.netfor-loop
bbesase
bbesase

Reputation: 861

Separating values in a textbox by special character

I have an asp.net/vb.net web app that requires information to be put into a multiline text box. If the user hits enter while in the textbox it drops down to next line, and they can enter more data in. When it tries to go to the database it fails because of the way the data is represented. I need help with looping through the field and getting each value.

This is how the data is represented in the DataTable

0;0.123;0.234;0.345;...

I need each value between the ; character... so I was thinking something like this?

If dbRow.Item("PV").ToString.Contains(";") Then

    For Each symbol As String In DBTable.Rows

        'get data b/w the ';'

     Next

End If

Any help would be greatly appreciated

Edit:

If dbRow.Item("PV").ToString.Contains(";") Then

   For Each s As String In dbRow.Item("PV").ToString

       Dim fields() As String = s.Split(";"c)

       For Each value As String In fields

            .Append("'" & CDbl(value) & "'," & "SysDate,1)")
             DBCommand.CommandText = myInsertIntoProperty_DataStringBuilder.ToString
             DBCommand.ExecuteNonQuery()
             myInsertIntoPropertyStringBuilder = New StringBuilder

        Next

     Next

    Else

            .Append("'" & CDbl(dbRow.Item("PV")) & "'," & "SysDate,1)")

    End If

Upvotes: 0

Views: 287

Answers (1)

SysDragon
SysDragon

Reputation: 9888

You mean something like this?

 Dim s As String In dbRow.Item("PV").ToString()
 Dim fields() As String = s.Split(";"c)

 For Each value As String In fields
     ' Do what you want with the value
 Next

Then access each value with field(0), fields(1), etc. You can then convert it to the appropriate type, for example:

Dim value As Double = Double.Parse(fields(0), CultureInfo.InvariantCulture)

Upvotes: 2

Related Questions