Perform operations on c++ DataTable
-
Please Richard a quick look at my previous post (also copied below)
"No, it still makes no sense. You add an extra column to your table and then you say you need to store information in extra rows. Choose one or the other."
I've added an extra ret column
DataColumn^rt_col=gcnew DataColumn();
rt_col->ColumnName = "Ret";
rt_col->DataType=System::Type::GetType("System.Double");
dbdataset->Columns->Add(rt_col);
Then I need to fill the rows of this new column "Ret" based on the values held in "Population" column.
1st value of "Ret" should equal = log( 1st value of Population / 2nd value of Population)
2nd value of "Ret" = log (3rd value of Population / 4th value of Population)
....ps: please let me reiterate that both "Ret" and "Population" are columns from the datable object dbdataset.
Cheers
** in vba it will take me <3 minutes to perform it but I am stuck in c++ (part of the learning process I suppose ) Again thanks for the help
-
And once again, I repeat, I have already shown you how to fill these columns. You just iterate through the rows of your datatable inserting the values (however you calculate them) into the Ret column of each row.
Thanks again Richard. Could this suggestion be translated into codes for implementation? then I will surely learn from your post as this is much more concrete. cheers
-
Thanks again Richard. Could this suggestion be translated into codes for implementation? then I will surely learn from your post as this is much more concrete. cheers
-
I showed you the codes at http://www.codeproject.com/Messages/4949941/Re-Perform-operations-on-cplusplus-DataTable.aspx[^]. I do not understand what more you are looking for.
Hi Richard, First and foremost, sincere apologies for a naivety mainly attributable to inexperience Yet. I acknowledge that the code posted is perfectly fine. While adapting to my needs, performing the loop before the below piece of code has resulted in blank "Ret" columns, confused me, and triggered some skepticism.
sda->Fill(dbdataset);
Now all look fine, and I'd like to thank you very much for your assistance. I spent the weekend on this mater whereas it took you barely few minutes from your side to bring a concrete solution. Hence I am indeed impressed, and hope to become a day a c++ pundit like you so as to give back by helping others on forums too.
Cheers
Member 11230372