asp.net 4 read csv file into Gridview

[DougP]

Getting Error on converting an array into a string

       Dim Filename As String = Session("SPMIDTextFile")
        Dim SPMIData, LineToRead As String
        Dim SPMID, CostTracker As String
        SPMIData = GetFileContents(Filename)
        Dim strReader As New StringReader(SPMIData)
        Dim a As Integer

        Dim SPMIDCostrakr As ArrayList
        Do While strReader.Peek() >= 0
            SPMIDCostrakr = strReader.ReadLine() '<<< Blue squiggly here, see below
        Loop
        ' Bind the results to the GridView   
        GridView1.DataSource = SPMIDCostrakr
        GridView1.DataBind()

Value of type 'string' cannot be converted to 'system.collections.arraylist'

What do I need to do to read a .CSV file into a datagrid?
BTW: its some 8000 lines long

DougP

 

[MarkSweetland]

Have to add to arrarys

SPMIDCostrakr.Add(strReader.ReadLine())

Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach

 

[DougP]

Ok that works, My file has two columns separated by a comma, and I would liek to bring it into the Gridview in 2 columns. How can I dod that?
SPMID | Costrakr
9999, ADSSDS
8888, DJJDJJ
etc
now it brings it into one column like so
the heading has the comma in it, and there is only one column
SPMID,CostTracker
10082A1,AABD0006
I need to use the split command looking for a comma and then make a 2 column array?

        Dim Filename As String = Session("SPMIDTextFile")
        Dim SPMIData As String
        SPMIData = GetFileContents(Filename)
        Dim strReader As New StringReader(SPMIData)
        Dim SPMIDCostrakr New ArrayList
        Do While strReader.Peek() >= 0
            SPMIDCostrakr.Add(strReader.ReadLine())
        Loop
        ' Bind the results to the GridView   
        GridView1.DataSource = SPMIDCostrakr
        GridView1.DataBind()

DougP

 

[jbenson001]

Use the Split() method on the "," when add it to the the ArrayList

 

[DougP]

ok can someone give me an example?
Split ???

DougP

 

[jbenson001]

Have you heard of Google?
Do some research before you ask for help

Try:

SPMIDCostrakr.Add(strReader.ReadLine().Split(","))

Something like that. You will to play around with it and see what works for you.