Printable View
Hello, I have an xls file, with 10 columns.
I want to pass the data to mysql.
My problem is that I shall find, sum of each row, max, min, average etc.
And I don't know how to do it.
When the data are filled to the dataset, and if this is the right solusion, how should I do this?
I can't find a way to work with rows.
OR fill my database, and do that operations with queries?
Thanks a lot
Once you've populated a DataTable you can call its Compute method to perform aggregations like that, e.g.vb.net Code:
first of all thanks for bothering.
I have mentioned although that I want to work with rows, not columns.
I have tried this method already.
When do you want to do this? Is it required in the same screen where you are importing data from Excel to MySQL or is it a 2 step process?Quote:
Originally Posted by manin
Like: Step1: Import all Excel data to MySQL
Step2: Show the aggregated values on another screen (fetching values from the MySQL and not excel).
I want the most easy and quick way.
I think the best is to import data to datatable, find the values I need,
and then export all data (excel and sum, min etc) to mysql.
If this cannot be done, then I should, follow your suggestion.
What you want can be done, I was not suggesting it can't be. But DataSet was built to replicate a bit of RDBMS that are all set based (or column based).
If you want to perform all those functions on a row-by-row basis then your only option is to iterate through all rows do the calculation and then export those values to MySQL.
It may also give a better idea to others if you provide some sample data. Something like below
As stored in DataTable:
Col1 Col2 Col3...
Name1 15 20
Name2 32 11
Name3 22 54 & so on.
As you want to store in MySQL
Name Avg Max...
Name1 17.5 20
Name2 21.5 32
Name3 38 54
This gives a better visual idea of what you are trying to achieve.
I will spend a few days more, searching a good solution, and I let you knowQuote:
Originally Posted by rjv_rnjn