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 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
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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:
...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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...
| |