Question Locked

VB.Net 2005 DataGridView problem

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

This discussion is closed to new replies.