Visual Basic:
try
{
string query1 = "SELECT DISTINCT CaseNo FROM ReceivingImport WHERE InvoiceNo='"+combo_Invoice.Items+"'";
SqlCeDataAdapter adapter = new SqlCeDataAdapter(query1,conn);
DataSet dtSet = new DataSet();
adapter.Fill(dtSet,"ReceivingImport");
combo_CaseNo.DataSource=dtSet.Tables["ReceivingImport"];
combo_CaseNo.DisplayMember="CaseNo";
I tried all possible methods for object combo_Invoice. But none of them give the value of the string display on the selection.
I even tried on text too.
How can it be solve