Ad:

ASP.NET Discussion Thread
Unsolved
Views: 1996

May 7th, 2008

split string to table

Expand Post »

Erm, how to split a string using comma separated into a table? Below is my code but the output seems weird:
Lets say the row has 40 elements and 30 rows:

ASP.NET Syntax (Toggle Plain Text)
For Count = 0 To UBound(MyArray)
            For a = 0 To UBound(MyArray)
                Dim celNew As New TableCell()
                'Dim rowNew As New TableRow()
                'MyArray = Split(strContents, ",")
                celNew.Text = MyArray(a)
                rowNew.Cells.Add(celNew)
                Table1.Rows.Add(rowNew)
            Next
        Next
For Count = 0 To UBound(MyArray)
            For a = 0 To UBound(MyArray)
                Dim celNew As New TableCell()
                'Dim rowNew As New TableRow()
                'MyArray = Split(strContents, ",")
                celNew.Text = MyArray(a)
                rowNew.Cells.Add(celNew)
                Table1.Rows.Add(rowNew)
            Next
        Next

Thanks.....

Similar Threads

Pivot table in DataGrid in VB.NET
SQL String question in ASP
How to split datetime format? in ASP.NET
Collapsible table sorting problem in JavaScript / DHTML / AJAX
can anyone make this tree table sort correctly? in JavaScript / DHTML / AJAX

evios

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

60 posts
since Sep 2007

Permalink

May 7th, 2008

Re: split string to table

Can you post the output you are getting so I can try to help you ?

majestic0110

Reputation Points: 256

Solved Threads: 72

Nearly a Posting Virtuoso

Offline

1,306 posts
since Oct 2007

Permalink

May 7th, 2008

Re: split string to table

Some how it just separate the string by comma, adding cell by cell and then repeat, look like this:

XXX XXXX XXXXX XXXXX XXXXXX
XXX XXXX XXXXX XXXXX XXXXXX
XXX XXXX XXXXX XXXXX XXXXXX
.
.
.
.
.

evios

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

60 posts
since Sep 2007

Permalink

May 8th, 2008

Re: split string to table

Ok post your code and I will try to help.

majestic0110

Reputation Points: 256

Solved Threads: 72

Nearly a Posting Virtuoso

Offline

1,306 posts
since Oct 2007

Permalink

May 9th, 2008

Re: split string to table

good...thanks first, lets say i have this randomized text file:
RFG678,1PASS,2FAILED,FGYIJUH,324,5,6,7
RF34S8,1PASS,2FAILED,FGYIJUH,324,1,6,6
.........
and i use the code below:

ASP.NET Syntax (Toggle Plain Text)
Dim strContents As String
        Dim objReader As StreamReader
        Dim MyArray As String()
        Dim a As Integer
        Dim Count As Integer
        objReader = New StreamReader("C://Index4.txt")
        strContents = objReader.ReadToEnd()
        objReader.Close()
        For Count = 0 To 67
            Dim rowNew As New TableRow()
            MyArray = Split(strContents, ",")
            For a = 0 To UBound(MyArray)
                Dim celNew As New TableCell()
                'Dim rowNew As New TableRow()
                'MyArray = Split(strContents, ",")
                celNew.Text = MyArray(a)
                Label11.Text = celNew.Text
                rowNew.Cells.Add(celNew)
            Next
            Table1.Rows.Add(rowNew)
        Next
Dim strContents As String
        Dim objReader As StreamReader
        Dim MyArray As String()
        Dim a As Integer
        Dim Count As Integer
        objReader = New StreamReader("C://Index4.txt")
        strContents = objReader.ReadToEnd()
        objReader.Close()
        For Count = 0 To 67
            Dim rowNew As New TableRow()
            MyArray = Split(strContents, ",")
            For a = 0 To UBound(MyArray)
                Dim celNew As New TableCell()
                'Dim rowNew As New TableRow()
                'MyArray = Split(strContents, ",")
                celNew.Text = MyArray(a)
                Label11.Text = celNew.Text
                rowNew.Cells.Add(celNew)
            Next
            Table1.Rows.Add(rowNew)
        Next

I just need to convert it into a table-like data, rows and columns separated nicely by line.
However if i using the code above, i just manage to get this:
RFG678 1PASS 2FAILED FGYIJUH 324 5 6 7 RF34S8 1PASS 2FAILED FGYIJUH 324 1 6 6

thanks

evios

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

60 posts
since Sep 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: Have anyone have the idea

Next Thread in ASP.NET Forum Timeline: table control

DaniWeb Message

Cancel Changes

User Name
Password