Read raw data from db a nd parse them?

  • Thread starter Thread starter feel
  • Start date Start date
F

feel

Hi,
i need to read data from an Access Database.
My problem is that all data have to be parsed or calculated so i'm looking
for the fastest way.

How to do that? Do i need a dataset or two ,first with raw data and the
second with calculated data?But in this case how to pass raw data from a
dataset to final data in second one?
Or use other components?
Anyone could point me the way to solve it?
Thanks
 
Feel,

What kind of calculations are you performing? If they are simple, then
you might be able to get away with setting the Expression property on a
column you add to the data set. However, it seems like you might want to do
something a little more complex. In that case, you might have to cycle
through all the rows and calculate the values you need when you initially
fetch the data.

Hope this helps.
 
What kind of calculations are you performing? If they are simple, then
you might be able to get away with setting the Expression property on a
column you add to the data set. However, it seems like you might want to do
something a little more complex. In that case, you might have to cycle
through all the rows and calculate the values you need when you initially
fetch the data.

Hope this helps.
Click to expand...

I have 6 fields and more or less 400 records.
I have to parse each s field extract some strings and in other extract some
numerical data that come in hex format.
What i need to have clear is if i have to fill the dataset with original
data from database and analyze them before showing ( listview or datagrid)
or if it's better to fill another dataset with already manipulated data and
show this second dataset or what?
Thanks again.
 
feel,

In this case, I would add a column (or more, depending on how many
values you have to calculate) to the original data set that is returned.
Then, I would cycle through the rows, and calculate the values, populating
the new column.

Check the Expression property on the DataColumn class. It is possible
that you could create a calculated column, and save yourself some code.
 
In this case, I would add a column (or more, depending on how many
values you have to calculate) to the original data set that is returned.
Then, I would cycle through the rows, and calculate the values, populating
the new column.

Check the Expression property on the DataColumn class. It is possible
that you could create a calculated column, and save yourself some code.


--
Click to expand...

Thanks for your prompt reply..
so in my case i have to add 6 columns ,each filled with parsed data, and
when finished looping and filling them with re-calculated data show their
value on screen.

Ok, will work on this.Thanks.
 
Hi,

Depending of the operations to perform you may do them when you build the
query to access the DB, I think this would be the fastest way, if you can do
it. take a look at the string manipulation functions access provides.


Cheers,
 
Back
Top