Ad:

VB.NET Discussion Thread
Unsolved
Views: 29536

Aug 4th, 2006

how to read data from text file into data grid???

Expand Post »

i need to create a system to read the txt file data to datagrid
but i just know read by line.

that say the sample.txt file pettern as below:

date time price
1/8 2:15pm $5.00
2/8 3:20pm $6.00

how i going to fill the data separate by date, time, and price??
means read by row n column....n fill into datagrid....
thanks....

if got sample to show then will be more better....:lol:

Similar Threads

Cant readline in text file.... URGENT help~ in VB.NET
writing students data to a text file in Assembly
Read comma separated data from a text file in C
help me to read my data file:(( in C
conversion of text file into data base file in Visual Basic 4 / 5 / 6

ohohling

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

7 posts
since Aug 2006

Permalink

Aug 4th, 2006

Re: how to read data from text file into data grid???

Hi

It looks like you have a set of " " between the columns, so what i would do is split each line one at a time, something like this:

VB.NET Syntax (Toggle Plain Text)
 
 
'after you read the line
Dim myArray As Array
myArray = Split(line, "  ")

'after you read the line
Dim myArray As Array
myArray = Split(line, "  ")

that will create an array with the data what you want. Probably you will have to trim each line to get rid of the empty spaces.

Hope it helps

Regards

williamrojas78

Reputation Points: 23

Solved Threads: 10

Junior Poster

Offline

111 posts
since Jun 2005

Permalink

Aug 6th, 2006

Re: how to read data from text file into data grid???

if the text file data is seperate by symbol ":" then how i going to do

sample data
RX:12/3/06

S1112:483720:E
RX:12/3/06

S1113:483721:-E

ohohling

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

7 posts
since Aug 2006

Permalink

Aug 7th, 2006

Re: how to read data from text file into data grid???

Then you split the array when ":" is found.

VB.NET Syntax (Toggle Plain Text)
 
'after you read the line
Dim myArray As Array
myArray = Split(line, ":")
'after you read the line
Dim myArray As Array
myArray = Split(line, ":")

regards

williamrojas78

Reputation Points: 23

Solved Threads: 10

Junior Poster

Offline

111 posts
since Jun 2005

Permalink

Mar 13th, 2008

Re: how to read data from text file into data grid???

Dear williamrojas78, ohohling
may i know how to read the data from the array?

after assign the txt line into the array by the code above. how can i take 1 by 1 and put it into datagrid?

thanks a lot

cheehongjb

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Mar 2008

Permalink

Mar 19th, 2008

Re: how to read data from text file into data grid???

Hi,

Here it is; first you read the array, then you read line by line and after that you place it in the grid.

VB.NET Syntax (Toggle Plain Text)
myArray = Split(line, ":")
 
Dim i As Integer
dim val as 
For i = 0 To myArray.Length - 1
     val = myArray(i)                'read the value of the items in the array
     dg.Item(row, column) = val      'place it in the datagrid
Next
myArray = Split(line, ":")

Dim i As Integer
dim val as 
For i = 0 To myArray.Length - 1
     val = myArray(i)                'read the value of the items in the array
     dg.Item(row, column) = val      'place it in the datagrid
Next

Dim myArray As Array

Hope it helps

williamrojas78

Reputation Points: 23

Solved Threads: 10

Junior Poster

Offline

111 posts
since Jun 2005

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 VB.NET Forum Timeline: From InputBox to ListBox??

Next Thread in VB.NET Forum Timeline: syntax Error..

DaniWeb Message

Cancel Changes

User Name
Password