I am still very new to the .net 2005, I have used vb6 for so many years it is getting dificult switching over to .net.
ok here is my problem I am trying to show info into a datagridview via SQL querry. I have figured out how to add your column names then adding 1 row at a time by reading in a SQLreader into the datagrid.
I am having now is my current queries will have different amount of columns and column names based on what the user selects. I have figured out how to add the column names correctly but I haven’t figure out how to add or fill the datagridview. I am building a very large sql statement based on user seletions and the amount and name of the columns is decided by the user selection so I can’t set anything static.
example: date range of 1-1-01 to 1-5-01 for item 1
SELECT ID, DESC, 1-1-01,1-2-01,1-3-01,1-4-01,1-5-01 FROM STUFF WHERE ITEM = 1
