populate a comboBox from DataSet

[Marc Jennings]

Hi there,

I'm new to C#, and I have a small problem.

I have created a new DataSet using the code below, and I would like to
be able to populat a drop-down list with the results of the "name"
field. Can anyone help me, please?

*************** *************** *************** ****

string m_Connect = "Data Source=(local); integrated
security=SSPI;I nitial Catalog=databas e_name;";
SqlConnection myConn = new SqlConnection(m _Connect);
SqlDataAdapter da = new SqlDataAdapter( );
myConn.Open();
DataSet ds1 = new DataSet();
string sQueryString1 = "";
sQueryString1 = "SELECT * FROM sysobjects where type='U'";
da.SelectComman d = new SqlCommand(sQue ryString1,myCon n);
da.Fill(ds1, "ImportTabl e");

*************** *************** *************** ****

Thanks,
Marc.

[Tamir Khason]

comboBox1.DataS ource = ds1;
comboBox1.Displ ayMember = "Whatever2S ee";
comboBox1.Value Member = "Whatever2Have" ;

Then to bound the combobox to the SelectedValue property using the DataTable
in ds1:

comboBox1.DataB indings.Add("Se lectedValue", this.ds1.Tables[0],
"Whatever2Have" );

Hope it helps
--
Tamir Khason
You want dot.NET? Just ask:
"Please, www.dotnet.us "
"Marc Jennings" <marc.nospam..j e******@gmail.c om> wrote in message
news:48******** *************** *********@4ax.c om...

Hi there,

I'm new to C#, and I have a small problem.

I have created a new DataSet using the code below, and I would like to
be able to populat a drop-down list with the results of the "name"
field. Can anyone help me, please?

*************** *************** *************** ****

string m_Connect = "Data Source=(local); integrated
security=SSPI;I nitial Catalog=databas e_name;";
SqlConnection myConn = new SqlConnection(m _Connect);
SqlDataAdapter da = new SqlDataAdapter( );
myConn.Open();
DataSet ds1 = new DataSet();
string sQueryString1 = "";
sQueryString1 = "SELECT * FROM sysobjects where type='U'";
da.SelectComman d = new SqlCommand(sQue ryString1,myCon n);
da.Fill(ds1, "ImportTabl e");

*************** *************** *************** ****

Thanks,
Marc.

[Marc Jennings]

Thanks for the quick reply...

If I understood you correctly, if I want to fill the combobox (called
tableslist) with the names of the tables, I should use the following
code....

tableslist.Data Source = ds1;
tableslist.Disp layMember = "name";
tableslist.Valu eMember = "name";
tableslist.Data Bindings.Add("S electedValue", ds1.Tables[0],"name");

It is a very simnple app to export the contents of a given table to
XML, so all the data retrieval happens in the same function - hence
the lack of "this."

I have tried the code above and it doesn't populate the list, so I
have to assume I have misunderstood what you meant.

On Thu, 1 Jul 2004 17:17:55 +0300, "Tamir Khason"
<ta**********@t con-NOSPAM.co.il> wrote:

comboBox1.Data Source = ds1;
comboBox1.Disp layMember = "Whatever2S ee";
comboBox1.Valu eMember = "Whatever2Have" ;

Then to bound the combobox to the SelectedValue property using the DataTable
in ds1:

comboBox1.Data Bindings.Add("S electedValue", this.ds1.Tables[0],
"Whatever2Have ");

Hope it helps

[Tamir Khason]

If your select return something like:
name id surname age
john 1 Dow 30
john 2 Brown 34
ann 3 Fox 21

by using this:

tableslist.Data Source = ds1;
tableslist.Disp layMember = "name";
tableslist.Valu eMember = "name"; you should recieve combobox of 3 items named john,john and ann with the same
values
while you select one of items and onSelectionChan ge writes age in other
textbox by using this:tableslist.Dat aBindings.Add(" SelectedValue", ds1.Tables[0],"name"); You will see 21 while select third item

This works fine for me

--
Tamir Khason
You want dot.NET? Just ask:
"Please, www.dotnet.us "
"Marc Jennings" <marc.nospam..j e******@gmail.c om> wrote in message
news:e6******** *************** *********@4ax.c om... Thanks for the quick reply...

If I understood you correctly, if I want to fill the combobox (called
tableslist) with the names of the tables, I should use the following
code....

tableslist.Data Source = ds1;
tableslist.Disp layMember = "name";
tableslist.Valu eMember = "name";
tableslist.Data Bindings.Add("S electedValue", ds1.Tables[0],"name");

It is a very simnple app to export the contents of a given table to
XML, so all the data retrieval happens in the same function - hence
the lack of "this."

I have tried the code above and it doesn't populate the list, so I
have to assume I have misunderstood what you meant.

On Thu, 1 Jul 2004 17:17:55 +0300, "Tamir Khason"
<ta**********@t con-NOSPAM.co.il> wrote:

comboBox1.Data Source = ds1;
comboBox1.Disp layMember = "Whatever2S ee";
comboBox1.Valu eMember = "Whatever2Have" ;

Then to bound the combobox to the SelectedValue property using the DataTablein ds1:

comboBox1.Data Bindings.Add("S electedValue", this.ds1.Tables[0],
"Whatever2Have ");

Hope it helps

[Marc Jennings]

Thanks again. I found out where it was all going wrong for me. I had
followed the instruction literally, and not thought to change the
DataSource from ds1 to ds1.Tables[0]

I can't believe I spent so long chasing my tail looking for this
simple answer!!!!

Thanks again.
Marc.

On Thu, 1 Jul 2004 17:43:28 +0300, "Tamir Khason"
<ta**********@t con-NOSPAM.co.il> wrote:

If your select return something like:
name id surname age
john 1 Dow 30
john 2 Brown 34
ann 3 Fox 21

by using this:

tableslist.Data Source = ds1;
tableslist.Disp layMember = "name";
tableslist.Valu eMember = "name";

you should recieve combobox of 3 items named john,john and ann with the same
values
while you select one of items and onSelectionChan ge writes age in other
textbox by using this:

tableslist.Da taBindings.Add( "SelectedValue" , ds1.Tables[0],"name");

You will see 21 while select third item

This works fine for me