Problem - SQl query using combobox

[azae]

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";

this code is C#. I am using combobox to do the selection.

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

[HJB417]

try

combo_CaseNo.DataSource=dtSet;

instead of

combo_CaseNo.DataSource=dtSet.Tables["ReceivingImport"];

[azae]

thanks for reply,

but the problem is not on the

combo_CaseNo.DataSet..........

 

the problem is on the query itself

I tried the hard code the statement,

the statement show

 

SELECT ....... WHERE InvoiceNo=""

 

which mean the invoice combo_CaseNo.Text or combo_CaseNo.Items have no value.

This cause the query is not successful.

[kejpa]

which mean the invoice combo_CaseNo.Text or combo_CaseNo.Items have no value.

This cause the query is not successful.

So basically you're asking how to get the text from a combobox.

You'd better hurry to windows forms or ASP subforums ;)

 

I'm not familiar with c# :(

But in vb combo_CaseNo.text returns the text of the combobox.

 

HTH

/Kejpa

[stustarz]

So basically you're asking how to get the text from a combobox.

You'd better hurry to windows forms or ASP subforums ;)

 

I'm not familiar with c# :(

But in vb combo_CaseNo.text returns the text of the combobox.

 

HTH

/Kejpa

 

MyCombo.SelectedItem.Value will return the value selected in the combo box.

[azae]

thank for the help..

but combobox.SelectedItem do not have method called "Value"

 

However, I managed get my things done while waiting for reply. Maybe I am still beginer, my coding is so messy. If possible in the future I might not want to use combobox anymore