Read raw data from db a nd parse them?

[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

[Nicholas Paldino [.NET/C# MVP]]

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.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"feel" <fe**@europeonline.com> wrote in message
news:aA**********************@news3.tin.it...

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

[Nicholas Paldino [.NET/C# MVP]]

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.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"feel" <fe**@europeonline.com> wrote in message
news:aA**********************@news3.tin.it...

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.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

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]

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.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

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.

[Nicholas Paldino [.NET/C# MVP]]

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.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"feel" <fe**@europeonline.com> wrote in message
news:lJ**********************@news3.tin.it...

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.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

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.

[Nicholas Paldino [.NET/C# MVP]]

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.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"feel" <fe**@europeonline.com> wrote in message
news:lJ**********************@news3.tin.it...

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.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

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.
--

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.

[Ignacio Machin \( .NET/ C# MVP \)]

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,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"feel" <fe**@europeonline.com> wrote in message
news:lJ**********************@news3.tin.it...

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.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

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.