Hi,
I've downloaded ExCheckedListBox from CodeProject. the control extends the ability of CheckedListBox by adding DataBinding feature.I have 3 tables: Table1,2 and Table3. Here is data for them:
Table1
ID1 Name
1 name1
2 name2
3 name3
Table3
ID3 price
1 200
2 300
3 400
Table2 (Joins Table1 and Table3)
ID1 ID3
1 1
1 2
2 3
Items of ExCheckedListBox are selected from Table 3.
When the user navigate records of Table1 in a RadGridView only the items which are related in Table2 must be checked. that is
when record with ID1=1 of Table1 is selected, then only price 200 and 300 must be checked in the ExCheckedListBox. Because in Table2, ID1=1 has two related records: 200(ID2=1) and 300(ID2=2) .
But how?
I've tested the Value property but I was not successfull.
Please guide me.
I've downloaded ExCheckedListBox from CodeProject. the control extends the ability of CheckedListBox by adding DataBinding feature.I have 3 tables: Table1,2 and Table3. Here is data for them:
Table1
ID1 Name
1 name1
2 name2
3 name3
Table3
ID3 price
1 200
2 300
3 400
Table2 (Joins Table1 and Table3)
ID1 ID3
1 1
1 2
2 3
Items of ExCheckedListBox are selected from Table 3.
When the user navigate records of Table1 in a RadGridView only the items which are related in Table2 must be checked. that is
when record with ID1=1 of Table1 is selected, then only price 200 and 300 must be checked in the ExCheckedListBox. Because in Table2, ID1=1 has two related records: 200(ID2=1) and 300(ID2=2) .
But how?
I've tested the Value property but I was not successfull.
Please guide me.
2 Answers, 1 is accepted
0
Tooraj
Top achievements
Rank 1
Rank 1
answered on 26 Oct 2010, 05:50 AM
Hi,
Why nobody answers my question?
Emanuel, where are you?
Why nobody answers my question?
Emanuel, where are you?
0
Emanuel Varga
Top achievements
Rank 1
Rank 1
answered on 26 Oct 2010, 07:27 AM
Hello,
You asked this question before and if I'm not mistaken I've gave you a few suggestions then also.
If you need to change the content of that ExCheckedListBox on selection changed, i would suggest using the RadGridView's CurrentRowChanged event, that way you can get always the current row from the grid and you can change the contents of the list based on that selection.
Hope this helps, if you have any other questions or comments, please let me know,
Best Regards,
Emanuel Varga
You asked this question before and if I'm not mistaken I've gave you a few suggestions then also.
If you need to change the content of that ExCheckedListBox on selection changed, i would suggest using the RadGridView's CurrentRowChanged event, that way you can get always the current row from the grid and you can change the contents of the list based on that selection.
Hope this helps, if you have any other questions or comments, please let me know,
Best Regards,
Emanuel Varga