Home visual studio 2010 add price of selected items from checklistbox in C# windows RJ raj RJ raj 0117 add price of selected items from checklistbox in C# windows

Question

1.00/5 (1 vote)

See more:

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.

What I have tried:

C#

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);
                
                }
            }

Posted 2-Jul-17 21:52pm

Member 13289720

Updated 2-Jul-17 22:55pm

Ehsan Sajjad

v2

Add a Solution

Comments

Prifti Constantine 3-Jul-17 3:58am

Does each item of the CheckListBox hold a value of type integer or decimal inside of it?
Or does it Hold the value : "English:1000" as a string type?

Member 13289720 3-Jul-17 4:02am

no sir, simple display subject name in cheklistbox and the subject fee is into the database of subject_master table. So, how i can do addition of each subject fee which i am selected from checklistbox

Prifti Constantine 3-Jul-17 4:23am

Have you stored the values that you have in the database inside a dataset or datatable in order to use them or even query them?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prifti Constantine · Accepted Answer · 2017-07-02T22:55:00

Solution 1

You could iterate though the List that is made to store inside the

C#

List<string> subjects = new List<string>();
            foreach (var item in chekBox.Items) {
                subjects.Add(item.ToString());
            }

           
   string sqlcommand = "Select * from tblSubjectRates where subjectName=@SubjectName";
            List<int> SubjectRates = new List<int>();
            using (SqlConnection con = new SqlConnection(connectionString)) {
                con.Open();
                using (SqlCommand cmd = new SqlCommand(sqlcommand, con)) {
                    foreach (var item in subjects) {
                        cmd.Parameters.AddWithValue("@SubjectName", item.ToString());
                        var x = cmd.ExecuteScalar();
                        SubjectRates.Add(Convert.ToInt32(x));
                    }                 
                    
                }
                int TotalSum = SubjectRates.Sum();
            }

I dont know if it will work... but give it a try.
I tried to generate it in my mind since i do not know your database schema in order to fully help you out. Just replace the keywords you think that will generate an error and i hope that this logic will work!
Best wishes and fingers crossed!

Posted 2-Jul-17 22:55pm

Prifti Constantine

Comments

Member 13289720 3-Jul-17 6:45am

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);
checkprice();
}
}
else
{
for (int i = 0; i < chklbselectsubject.Items.Count; i++)
{
chklbselectsubject.SetItemChecked(i, false);
checkprice();
}
}
}

private void checkprice()
{

SqlConnection con = new SqlConnection(cs.DBcon);
con.Open();
string strsql = "Select Sum(fee) from Subject_Master where Sub_Name='"+chklbselectsubject.SelectedItems+"'";
SqlCommand cmd= new SqlCommand(strsql, con);

object sum = cmd.ExecuteScalar();
txtTotalfee.Text = sum.ToString();
con.Close();

}

but additon not done .......Plz help

Prifti Constantine 3-Jul-17 6:56am

Have you debuged to see what kind of value chklbselectsubject.SelectedItems returns? The way i see it, due to seeing your code for the first time, the error might possibly occur on the selection of the "chklbselectsubject". Also the variable sum doesnt need to be of type object since the sum will probably return an integer value type or mostly double since we are talking for a value type return from the database.

Member 13289720 3-Jul-17 7:28am

when i using int sum=cmd.executeScalar()
i got an error cannot implicitly convert type 'object' to 'int' an explicit conversion exists.and also the subject not selected from the where condition
how can i do

Prifti Constantine 3-Jul-17 8:05am

You could change the execute scalar part with the ExecuteReader();
using(sqlDataReader reader = cmd.ExecuteReader())
{
While(reader.Read())
{
int x = Convert.toInt32(reader["price"].toString());
}
}

or Cast the executeScalar() with (int) :
Sum = (int)cmd.executeScalar();

Member 13289720 3-Jul-17 10:28am

yes its work, but...when i don't use where condition in query then all fee are calculate from tblsubject table i want only selected subject
how i can use query because [where Sub_Name='"+chklbselectsubject.SelectedItems+"'";] its not working

Prifti Constantine 3-Jul-17 10:56am

Thats because chklbselectsubject.SelectedItems probably returns many values depending on how many values the user has selected. In this situation if the user Selects 2 values then the 2 of them cannot pass as a parameter in the query. What you need to do is take each value, one by one and Change the parameters accordingly.
I am giving you an example:
foreach item in list
{
[where Sub_Name='"+item.ToString+"'"]
}
I hope it is clear enough.

Member 13289720 3-Jul-17 11:14am

thank you Sir, its work fine

Prifti Constantine 3-Jul-17 14:11pm

Have a good one my friend! Keep on coding!