Formatting data using a data grid
-
Does anyone have an examples/ideas about how to format data using a datagrid in VB Net - maybe its not possible to do this with a simple data grid My data comes from two tables w multiple records for the same id number and name. I don't want to keep repeating id and name fields It comes out like this in the datagrid: ID1 Name1 data group1 (several fields) ID1 Name1 data group2 (several fields) ID1 Name1 data group3 (several fields) ID1 Name1 data group4 (several fields) ID1 Name1 data group5 (several fields) ID2 Name2 data group1 (several fields) ID2 Name2 data group2 (several fields) etc I'd want to look something like this: ID1 Name1 data group1 (several fields) data group2 (several fields) data group3 (fields) etc ID2 Name2 data group1 (several fields) data group2 (several fields) data group3 (fields) etc ID3 Name3 data group1 (several fields) data group2 (several fields) data group3 (fields) etc OR maybe like this ID1 Name1 data group1 data group 2 data group 3 data group 4 etc ID2 Name 2 data group1 data group 2 data group 3 data group 4 etc Thanks
-
Does anyone have an examples/ideas about how to format data using a datagrid in VB Net - maybe its not possible to do this with a simple data grid My data comes from two tables w multiple records for the same id number and name. I don't want to keep repeating id and name fields It comes out like this in the datagrid: ID1 Name1 data group1 (several fields) ID1 Name1 data group2 (several fields) ID1 Name1 data group3 (several fields) ID1 Name1 data group4 (several fields) ID1 Name1 data group5 (several fields) ID2 Name2 data group1 (several fields) ID2 Name2 data group2 (several fields) etc I'd want to look something like this: ID1 Name1 data group1 (several fields) data group2 (several fields) data group3 (fields) etc ID2 Name2 data group1 (several fields) data group2 (several fields) data group3 (fields) etc ID3 Name3 data group1 (several fields) data group2 (several fields) data group3 (fields) etc OR maybe like this ID1 Name1 data group1 data group 2 data group 3 data group 4 etc ID2 Name 2 data group1 data group 2 data group 3 data group 4 etc Thanks
It looks like Pivot Table... I don't know if Datagrid Control in VB can does. How about this.. you unbound your datagrid with your datasource.. You will create several collection/array to act as buffer/dataset for your data Then you will put that data into datagrid cell like the way you want to. It make sense?