By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,254 Members | 2,418 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,254 IT Pros & Developers. It's quick & easy.

Putting Raw formatted Data in proper datatype and displaying

P: n/a
I have raw formated data (comma separated), and I like to store it in a good
datatype/collection object. And display the data in the data object in a
HTML table.
The data looks like this:

Date,XYZ,PEAK,Price,Number,Volume
14-Jan-05,ABC,123,26.04,26.12,92180800
13-Jan-05,ABC,123,26.04,26.12,92180800
12-Jan-05,ABC,123,26.04,26.12,92180800
11-Jan-05,ABC,123,26.04,26.12,92180800


Thanks in advance
Nov 19 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
What is your exact question? Are in looking for answers about how to parse
the data, create custom collections, render the content as HTML, or
something else?

"jty202" <jt****@gmail.com> wrote in message
news:et**************@TK2MSFTNGP10.phx.gbl...
I have raw formated data (comma separated), and I like to store it in a good datatype/collection object. And display the data in the data object in a
HTML table.
The data looks like this:

Date,XYZ,PEAK,Price,Number,Volume
14-Jan-05,ABC,123,26.04,26.12,92180800
13-Jan-05,ABC,123,26.04,26.12,92180800
12-Jan-05,ABC,123,26.04,26.12,92180800
11-Jan-05,ABC,123,26.04,26.12,92180800


Thanks in advance

Nov 19 '05 #2

P: n/a
What is a good way to read these data into a data collection or data object
(recordset?)

What is a good way to diaplay the data from the data collection or data
object ( recordset?) in to HTML Table (a binded table?)?
"Peter Rilling" <pe***@nospam.rilling.net> wrote in message
news:Oi**************@TK2MSFTNGP15.phx.gbl...
What is your exact question? Are in looking for answers about how to parse the data, create custom collections, render the content as HTML, or
something else?

"jty202" <jt****@gmail.com> wrote in message
news:et**************@TK2MSFTNGP10.phx.gbl...
I have raw formated data (comma separated), and I like to store it in a

good
datatype/collection object. And display the data in the data object in a HTML table.
The data looks like this:

Date,XYZ,PEAK,Price,Number,Volume
14-Jan-05,ABC,123,26.04,26.12,92180800
13-Jan-05,ABC,123,26.04,26.12,92180800
12-Jan-05,ABC,123,26.04,26.12,92180800
11-Jan-05,ABC,123,26.04,26.12,92180800


Thanks in advance


Nov 19 '05 #3

P: n/a
You can put them as an array by using string.split

"jty202" wrote:
What is a good way to read these data into a data collection or data object
(recordset?)

What is a good way to diaplay the data from the data collection or data
object ( recordset?) in to HTML Table (a binded table?)?
"Peter Rilling" <pe***@nospam.rilling.net> wrote in message
news:Oi**************@TK2MSFTNGP15.phx.gbl...
What is your exact question? Are in looking for answers about how to

parse
the data, create custom collections, render the content as HTML, or
something else?

"jty202" <jt****@gmail.com> wrote in message
news:et**************@TK2MSFTNGP10.phx.gbl...
I have raw formated data (comma separated), and I like to store it in a

good
datatype/collection object. And display the data in the data object in a HTML table.
The data looks like this:

Date,XYZ,PEAK,Price,Number,Volume
14-Jan-05,ABC,123,26.04,26.12,92180800
13-Jan-05,ABC,123,26.04,26.12,92180800
12-Jan-05,ABC,123,26.04,26.12,92180800
11-Jan-05,ABC,123,26.04,26.12,92180800


Thanks in advance



Nov 19 '05 #4

P: n/a
JTY,

A recordset is set of records in ADODB I don't believe you want that.

When your data is a file than you can use this when it is in VBNet code.

\\\
Private Sub Form1_Load(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
Dim file As String = "Test2.txt"
Dim path As String = "C:\Test1\"
Dim ds As New DataSet
Try
Dim f As System.IO.File
If f.Exists(path & file) Then
Dim ConStr As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
path & ";Extended Properties=""Text;HDR=No;FMT=Delimited\"""
Dim conn As New OleDb.OleDbConnection(ConStr)
Dim da As New OleDb.OleDbDataAdapter("Select * from " & _
file, conn)
da.Fill(ds, "TextFile")
End If
Catch ex As Exception
MessageBox.Show(ex.ToString)
End Try
End Sub
///

See for an answer on you datetime question your later sent message.

I hope this helps a little bit?

Cor
Nov 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.