奖品查询代码

步骤一

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