string strSQL2;
strSQL2 = "SELECT SUP_NO,STR(SUP_NO) + ' ' +COMPANY_NAME AS SC FROM t_b_SUPPLIER WHERE STATUS!=9 ORDER BY SUP_NO ASC";
SqlDataAdapter da2 = new SqlDataAdapter(strSQL2, conn);
DataSet ds2 = new DataSet();
da2.Fill(ds2,"supplier");
SUP_NO.DataSource = ds2 ;
SUP_NO.DisplayMember = "supplier.SC";
SUP_NO.ValueMember = "supplier.SUP_NO";
SUP_NO.SelectedIndex = -1;
我用FindString方法不能查找到这个COMBOBOX中输入的字符所对应的值,我检查发现是因为DisplayMember 中STR(SUP_NO) + ' ' +COMPANY_NAME AS SC 原来SUP_NO进行了字符转换,请问我该如何才能找到对应的值呢?
int sup_no = SUP_NO.FindString(SUP_NO.Text.Trim());
SUP_NO.SelectedIndex = sup_no;
strSQL2 = "SELECT SUP_NO,STR(SUP_NO) + ' ' +COMPANY_NAME AS SC FROM t_b_SUPPLIER WHERE STATUS!=9 ORDER BY SUP_NO ASC";
SqlDataAdapter da2 = new SqlDataAdapter(strSQL2, conn);
DataSet ds2 = new DataSet();
da2.Fill(ds2,"supplier");
SUP_NO.DataSource = ds2 ;
SUP_NO.DisplayMember = "supplier.SC";
SUP_NO.ValueMember = "supplier.SUP_NO";
SUP_NO.SelectedIndex = -1;
我用FindString方法不能查找到这个COMBOBOX中输入的字符所对应的值,我检查发现是因为DisplayMember 中STR(SUP_NO) + ' ' +COMPANY_NAME AS SC 原来SUP_NO进行了字符转换,请问我该如何才能找到对应的值呢?
int sup_no = SUP_NO.FindString(SUP_NO.Text.Trim());
SUP_NO.SelectedIndex = sup_no;
http://www.codeproject.com/managedcpp/mcppautocombo.asp
http://www.codeproject.com/vb/net/AutoCompleteComboBox.asp