日期:2014-05-16 浏览次数:20987 次
private void cmbcustomer_TextChanged(object sender, EventArgs e)
{
string sql = "select customer_code,customer_name from sys_customer where customer_name like '%" + this.cmbcustomer.Text + "%'";
DataTable dt = DBHelp.GetDataSet(sql);
this.cmbcustomer.Items.Clear();
foreach (DataRow dr in dt.Rows)
{
this.cmbcustomer.Items.Add(dr["customer_name"].ToString());
}
}