Hi there to all,
I'm a newbie at programming and still learning so please be gentle
Using C# visual studio 2017 , sql database
So i have this massive database from which i collect data. The data i collect with a sql and finally display on a form with a datagridview.
The data which is displayed could be data containing serial nrs or batch nrs.
So i select some data from 3 different tables with some joins, the selection is made on base of a project nr.
When the data contains a column with serial nrs.... There is no problem. But when it contains a column with batch nrs i have a problem.
The problem:
In the database there is data with for instance 5 times the same batchnr. The data i collect from it tells me this ( one field is a number field which tells me how many batch nr there should be).
So in the datagrid view i see 1 row with many column. What i need in this case is 5 rows.
What are the options to solve this:
Can i copy and paste the row 4 times in the datagridview
or should i work with my temp table before i fill the datagridview.
I hope that someone can point me in the right direction
I'm a newbie at programming and still learning so please be gentle
Using C# visual studio 2017 , sql database
So i have this massive database from which i collect data. The data i collect with a sql and finally display on a form with a datagridview.
The data which is displayed could be data containing serial nrs or batch nrs.
So i select some data from 3 different tables with some joins, the selection is made on base of a project nr.
When the data contains a column with serial nrs.... There is no problem. But when it contains a column with batch nrs i have a problem.
The problem:
In the database there is data with for instance 5 times the same batchnr. The data i collect from it tells me this ( one field is a number field which tells me how many batch nr there should be).
So in the datagrid view i see 1 row with many column. What i need in this case is 5 rows.
What are the options to solve this:
Can i copy and paste the row 4 times in the datagridview
or should i work with my temp table before i fill the datagridview.
I hope that someone can point me in the right direction