473,326 Members | 2,127 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Putting Raw formatted Data in proper datatype and displaying

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 16 '05 #1
4 1154
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 16 '05 #2
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 16 '05 #3
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 16 '05 #4
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 16 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: EMiller | last post by:
Hello, I am encountering a development challenge here that seems to be stumping me. I am developing a C#/.NET application using an MSDE database. There is a particular field in a table that I...
0
by: GMG | last post by:
Background : with XML data islands you can bind data to HTML tags. If you do not provide a DTD it will display the information as is. If you provide a DTD IE will display the data according to its...
3
by: vinayak | last post by:
Hi I am displaying data in Datagrid in ASP.NET with Edit/Update functionality for each row. On the same page I have 2 Button controls which submits the request to server. These button controls...
4
by: jty202 | last post by:
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: ...
4
by: Vigneshwar Pilli via DotNetMonster.com | last post by:
Hey, Well, I have a Problem. I have designed a table which has few fields which are being declared in the database of type .... char of length 10. and other fields with varchar 50 and...
7
by: | last post by:
Hello, Does anyone have an idea on how I can filter the data in the gridview control that was returned by an sql query? I have a gridview that works fine when I populate it with data. Now I...
1
by: bbawa1 | last post by:
Hi, I have text boxes in my web form. I am typing phone number 1-769-876-2345. and try to insert this data in a column named Cellphone which is of data type numeric(18,0). But it is giving me...
0
by: suprodeep | last post by:
have a page for admin(admin.aspx). This would enter product name, image, category name and and long description in a formatted manner. The prod name, image, category name can be inputted to...
0
by: Kumba | last post by:
Hi all, Working on a pretty fancy access report that prints out a schedule of events in a two-column format, I've stumbled across the need for displaying formatted text into a field. Since I'm...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.