问题描述
Plz帮助我！
我正在开发一个VS 2010 C＃windows窗体应用程序，这样当我从combobox选择课程然后复选框时，我有一个带有主题名称的checkedlistbox显示与课程名称相关的所有科目。我也有简单的复选框（选择所有主题），我想检查所有主题或检查特定主题。现在，当我检查主题时，将添加费用并显示在文本框中。费用列入主题表数据库
例如：
主题名称=费用
Checkedlistbox项目1英语= 1000
Checkedlistbox项目2印地语= 500
Checkedlistbox项目3 Marathi = 800
Checkedlistbox项目4 Science = 2000
Checkedlistbox项目....... n
在选定的主题事件上，如果我检查了项目1,2和4，我想要textbox1中显示的这些值的总和（即3500）
。
非常感谢。
我尝试过的方法：
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:
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);
}
}推荐答案
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!
这篇关于家庭视觉工作室2010从C＃windows RJ raj RJ raj 0117中的checklistbox中添加所选项目的价格从C＃windows中的checklistbox中添加所选项目的价格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！