Problem - SQl query using combobox

A

azae

Member
Joined
Jan 6, 2005
Messages
18
[VB]
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";
[/VB]
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
 
try
[VB]
combo_CaseNo.DataSource=dtSet;
[/VB]
instead of
[VB]
combo_CaseNo.DataSource=dtSet.Tables["ReceivingImport"];
[/VB]
 
thanks for reply,
but the problem is not on the
[VB]
combo_CaseNo.DataSet..........
[/VB]

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.
 
azae said:
which mean the invoice combo_CaseNo.Text or combo_CaseNo.Items have no value.
This cause the query is not successful.
Click to expand...
So basically youre asking how to get the text from a combobox.
Youd better hurry to windows forms or ASP subforums ;)

Im not familiar with c# :(
But in vb combo_CaseNo.text returns the text of the combobox.

HTH
/Kejpa
 
kejpa said:
So basically youre asking how to get the text from a combobox.
Youd better hurry to windows forms or ASP subforums ;)

Im not familiar with c# :(
But in vb combo_CaseNo.text returns the text of the combobox.

HTH
/Kejpa
Click to expand...

MyCombo.SelectedItem.Value will return the value selected in the combo box.
 
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
 
Back
Top