步骤一
1创建winform窗体
步骤二
1拖拽list控件、两个按钮控件、Label控件
*删除按钮的功能:奖品查询的要求是根据list内容中选择的文本进行对其的删除
*查询按钮的功能:根据list文档中所选的文本进行数据库中的奖品数据的统计
private void button2_Click(object sender, EventArgs e)
{
string awards="";
//在列表项中进行的被选数据的个数的记录
int count = this.listBox1.SelectedItems.Count;
//将所选的数据进行输出
for(int i=0;i<count;i++)
{
awards=awards+"'"+this.listBox1.Items[i].ToString()+"'"+",";
}
awards=awards.Trim(',');//删除字符串中的无用的符号
MessageBox.Show(awards);//进行测试,显示所选定的内容
string sql = ConfigurationManager.ConnectionStrings["sql"].ConnectionString;
SqlConnection conn = new SqlConnection(sql);
conn.Open();
SqlCommand comm = conn.CreateCommand();
comm.CommandText = "select * from information where award in("+awards+")";
SqlDataAdapter adapter = new SqlDataAdapter(comm);
DataTable data = new DataTable();
adapter.Fill(data);
conn.Close();
comm.Dispose();
conn.Dispose();
#region 进行数据个数的统计
int tcount = 0;
int vcount = 0;
int ucount = 0;
for (int i = 0; i < data.Rows.Count; i++)
{
string award = data.Rows[i][5].ToString();
switch (award)
{
case "T恤":
tcount++;
break;
case "U盘":
ucount++;
break;
case "VIP充值卡":
vcount++;
break;
}
}
this.label1.Text = "T恤数量为" + tcount + "U盘数量为" + ucount + ",VIP充值卡数量为" + vcount;
#endregion
}
}
}