using System.Data.SqlClient;
using System.Linq;
public void LoadName(string value)
{
try
{
SqlCommand cmd = new SqlCommand("select ProductID as ID, ProductName as Name from Product where ProductType=@ProductType", sql);
cmd.Parameters.Add("@ProductType", SqlDbType.VarChar, 20, "ProductType").Value = value;
if (sql.State == ConnectionState.Closed)
sql.Open();
using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
CheckedListBox.ValueMember = "ID"; // 绑定数据之前赋值。
CheckedListBox.DataSource = dr.Cast<System.Data.Common.DbDataRecord>().ToList();
CheckedListBox.DisplayMember = "Name";
}
}
catch
{
if (sql.State == ConnectionState.Open)
sql.Close();
}
}