add price of selected items from checklistbox in c# windows

RJ Raj

9y3.6k

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 1,2 and 4, I want the sum of these values (i.e 3500)

displayed in textbox1.

Many thanks.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta9y ago
Accepted 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.
0
RJ Raj9y ago
Thank u, its work
0
RJ Raj9y ago
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.Items.Count; i++)
{
chklbselectsubject.SetItemChecked(i, true);
}
}
else
{
for (int i = 0; i < chklbselectsubject.Items.Count; i++)
{
chklbselectsubject.SetItemChecked(i, false);
}
}

}

0
Amit Gupta9y ago
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
0