Question

C#combobox控件赋值，急！

具体问题信息如下：using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;namespace t13Test
{
public partial class deletes : Form
{
public deletes()
{
InitializeComponent();
}private void deletes_Load(object sender, EventArgs e)
{
int i = 0;
SqlConnection conn = new SqlConnection("server=.;database=HotelManage;uid=sa");
SqlCommand cmd = new SqlCommand("select * from roomtype", conn);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
comboBox1.Items.Add(dr[1].ToString());
listView1.Items.Add(dr[1].ToString());
listView1.Items[i].SubItems.Add(dr[2].ToString());
i++;}
dr.Close();
conn.Close();}利用combobox把选中的值，赋到listView里面

Answer 1

....这个问题属 下拉列表赋值问题，可分为静态赋值和动态赋值...e.g:private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{listView1.Items.Clear();清以前的内容.
int i = 0;
SqlConnection conn = new SqlConnection("server=.;database=HotelManage;uid=sa");
SqlCommand cmd = new SqlCommand("select * from roomtype Where 房间类型='" + comboBox1.Text + "'", conn);//注意这里用Combobox的文本构造了一个SQL命令，然后执行就可以了,非常简单当然你也可以采用参数化的方式,如下://SqlCommand cmd = new SqlCommand("select * from roomtype Where 房间类型=@typename", conn);
//SqlParameter p = new SqlParameter("@typename", SqlDbType.VarChar);
//p.Value=comboBox1.Text;
//cmd.Parameters.Add(p);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
comboBox1.Items.Add(dr[1].ToString());
listView1.Items.Add(dr[1].ToString());
listView1.Items[i].SubItems.Add(dr[2].ToString());
i++;}
dr.Close();
conn.Close();
}用字符串拼接方式,简单,但不安全,容易被SQL注入.参数化方式麻烦一些,但不会被注入.