VRao
10-10-2007, 07:12 AM
Hi,
I'm new to ASP.NET. I want to create a dynamic datagrid based from MS SQL select statement.
The thing is i want those data to produce like below grid.
Date..............Jim...Bond...Kelly
01/01/2005...2.2....1.9......2.2
02/01/2005...2.1....1.8......2.1
The word "Jim, Bond, Kelly and many more" are dynamically from SQL statement. So it's like the header is dynamic word.
All are dynamic data except the word "Date". Another thing, i want the grid table to be separate when they reach 4 column and proceed next column at bottom of the grid or can say another grid. Example:
Date..............Jim...Bond...Kelly
01/01/2005...2.2....1.9......2.2
02/01/2005...2.1....1.8......2.1
Date..............James...Charley...White
01/01/2005.....2.2..........1.9..........2.2
02/01/2005.....2.1..........1.8..........2.1
PLEASE HELP ME.
I have no idea on how to do this.
*** The datagrid i specify above is not showing correctly after post the question. Not sure y***
I'm new to ASP.NET. I want to create a dynamic datagrid based from MS SQL select statement.
The thing is i want those data to produce like below grid.
Date..............Jim...Bond...Kelly
01/01/2005...2.2....1.9......2.2
02/01/2005...2.1....1.8......2.1
The word "Jim, Bond, Kelly and many more" are dynamically from SQL statement. So it's like the header is dynamic word.
All are dynamic data except the word "Date". Another thing, i want the grid table to be separate when they reach 4 column and proceed next column at bottom of the grid or can say another grid. Example:
Date..............Jim...Bond...Kelly
01/01/2005...2.2....1.9......2.2
02/01/2005...2.1....1.8......2.1
Date..............James...Charley...White
01/01/2005.....2.2..........1.9..........2.2
02/01/2005.....2.1..........1.8..........2.1
PLEASE HELP ME.
I have no idea on how to do this.
*** The datagrid i specify above is not showing correctly after post the question. Not sure y***