How to create a column dynamically in datatable?

See more:

C#

DataTable

MongoDB

In this way, the data comes from the database in a mixed way with different prices.

1. Product = Laptop Price=100 Quantity=105
2. Product = Monitor Price=110 Quantity=130
3. Product = Tel Price=200 Quantity=250
4. Product= TV Price=200 Quantity=250
5. Product= Monitor Price=140 Quantity=70
6. Product= TV Price=350 Quantity=50
7. Product= TV Price=500 Quantity=20
8. Product= Laptop Price=150 Quantity=50

I have data I retrieved using mongodb.
This data is filtered by date and returns the price/product ratio in the selected date range.
A product can be displayed at one price or at multiple prices.

In the datatable I created, only the product name is statically available.
There will be as many columns and rows as the content of the data coming from the database.
How can I prepare this?

I can do this manually in a static way.

But when the date filter expands, I won't know how many of the incoming data are and I can't prepare the table accordingly.


| Product | Price1 |Quantity1| Price2 | Quantity2 | PriceN | QuantityN |
-----------|---------|-------- |--------|-------- |----- |-------- |
| Laptop | 100 | 105 | 150 | 50 | | |
| Monitor | 110 | 130 | 140 | 70 | | |
| Tel | 200 | 250 | | | | |
| TV | 200 | 250 | 350 | 50 | 500 | 20 |



A table like this will appear.
But this table will be determined according to the data from the database.
I couldn't manage to create it dynamically...

--

What I have tried:

if this item exists in the table this way i get which row it is in



DataColumn[] colums = dt.Columns.Cast<datacolumn>().ToArray();
listed= dt.AsEnumerable()
.Any(row => colums.Any(col => row[col].ToString() == product));
if(listed==true){DataRow drow = dt.Select(("ProductName=\'" + (product+ "\'")))[0];
int tempIndex = dt.Rows.IndexOf(drow);}


it all starts here..
I don't know how many prices for this product have been entered.
Maybe the first price..
maybe third price.

It will create a new column whatever information was entered last and add the new information there.