add price of selected items from checklistbox in c# windows

Question

Plz help me! I am developing a VS 2010 C# windows form application such that I have a checkedlistbox with subject name when i choose course from combobox then checkboxlist shows all subject related to course name. also I have simple checkbox for (select all subject) i want to check all subject or check particular subject . Now when i checked subject then fee will be added and show on textbox . fee is given into the database of subject table For example: Subject Name= Fee Checkedlistbox item 1 English= 1000 Checkedlistbox item 2 Hindi = 500 Checkedlistbox item 3 Marathi = 800 Checkedlistbox item 4 Science= 2000 Checkedlistbox item .......n On a subject selected event If for instance I checked items 12 and 4 I want the sum of these values (i.e 3500) displayed in textbox1. Many thanks.

Amit Gupta · Answer

I cannot send the complete code for this but I can tell you the logic (as there are many). As you are fetching subject on the checkboxlist you can use simple query like this to sum the fee just you need to fetch the name of the checked subject (that you had already achieved) Select sum(fee) as Fee where subject in ('English' 'Hindi'); This query will sum up all the fees according to the selected subject.

RJ Raj · Answer

Thank u its work

RJ Raj · Answer

thx sir but i really didn't understand how to add the subject fee **Simple i display subject name in checklistbox and the subject fee is into the database of tblsubject table. So how i can do addition of each subject fee which i am selected subject from checklistbox instead of following code private void chkselectsubject_CheckedChanged(object sender EventArgs e) { if (chkselectsubject.Checked) { for (int i = 0; i { chklbselectsubject.SetItemChecked(i true); } } else { for (int i = 0; i { chklbselectsubject.SetItemChecked(i false); } } }

Amit Gupta · Answer

As you are having all the logic then whats the problem. Where did you stuck? Use loop through the checkboxlist to get checked items and sum them. https://stackoverflow.com/questions/12429655/getting-checkboxlist-item-values