chiuchimuN
Programmer
I have two table with fields:
ID,Date ,Payment
1 , 1/5 , 100
3 , 1/5 , 150
1 , 2/5 , 100
2 , 2/5 , 300
3 , 2/5 , 150
1 , 3/5 , 100
etc...
ID , Name ,Due ,Tele1 , Tele2 , Address , ....
1 ,John Do ,100 ,(310)-..
2 ,Mary J ,110
3 ,Bill W ,100
etc...
I want to place values in listview control(newer version that has the checkbox in list) and look like:
ID, Name , 1/5 , 2/5 , 3/5 .....
1 ,John Do , 100 , 100 , 100
2 ,Mary J , , 300 ,
3 ,Bill W , 150 , , 150
etc....
I can't figure out the code I need to write because most Books and MSDN show examples of bound controls(very little on implementing unbound controls. I can't use a cross tab query because I need features available in listview.
Help much appreciated.
ID,Date ,Payment
1 , 1/5 , 100
3 , 1/5 , 150
1 , 2/5 , 100
2 , 2/5 , 300
3 , 2/5 , 150
1 , 3/5 , 100
etc...
ID , Name ,Due ,Tele1 , Tele2 , Address , ....
1 ,John Do ,100 ,(310)-..
2 ,Mary J ,110
3 ,Bill W ,100
etc...
I want to place values in listview control(newer version that has the checkbox in list) and look like:
ID, Name , 1/5 , 2/5 , 3/5 .....
1 ,John Do , 100 , 100 , 100
2 ,Mary J , , 300 ,
3 ,Bill W , 150 , , 150
etc....
I can't figure out the code I need to write because most Books and MSDN show examples of bound controls(very little on implementing unbound controls. I can't use a cross tab query because I need features available in listview.
Help much appreciated.