How I populate Listbox with dataset?

[Lasse Edsvik]

Hello

I've created a class that has a method that returns a dataset like this:

public DataSet GetAllCustomers()

{

Open();

DataSet ds = new DataSet();

SqlDataAdapter da = new SqlDataAdapter();

da.SelectCommand = new SqlCommand("CustListAll", dbconn);

da.Fill(ds);

return ds;

}

Then I added a new project and then tried to do this:

public Form1()

{

InitializeComponent();

Northwind n = new Northwind();

listBox1.DataSource = n.GetAllCustomers();

listBox1.DisplayMember = "CustomerName";

listBox1.Text = "CustomerName";

}

When I run it only has a text
"System.Data.DataViewManagerListItemType.Descripto r" in it

errrm? :) what to do here to get it to show in listbox?

/Lasse

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

My advise is you to read about bind in windows forms, google: windows forms
data bind

You need to especify the table from where the columns will come from, I got
this piece of code from the first link in the above search

private DataViewManager dsView;
private DataSet ds;

dsView = ds.DefaultViewManager;

// Combobox Databinding
cbCust.DataSource = dsView;
cbCust.DisplayMember = "Customers.CompanyName";
cbCust.ValueMember = "Customers.CustomerID";

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Lasse Edsvik" <la***@nospam.com> wrote in message
news:ek*************@TK2MSFTNGP15.phx.gbl...

Hello

I've created a class that has a method that returns a dataset like this:

public DataSet GetAllCustomers()

{

Open();

DataSet ds = new DataSet();

SqlDataAdapter da = new SqlDataAdapter();

da.SelectCommand = new SqlCommand("CustListAll", dbconn);

da.Fill(ds);

return ds;

}

Then I added a new project and then tried to do this:

public Form1()

{

InitializeComponent();

Northwind n = new Northwind();

listBox1.DataSource = n.GetAllCustomers();

listBox1.DisplayMember = "CustomerName";

listBox1.Text = "CustomerName";

}

When I run it only has a text
"System.Data.DataViewManagerListItemType.Descripto r" in it

errrm? :) what to do here to get it to show in listbox?

/Lasse

[Lasse Edsvik]

hmm k,

changing to:

listBox1.DataSource = n.GetAllCustomers().DefaultViewManager;

didnt help much either :(

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us> wrote
in message news:uW**************@TK2MSFTNGP15.phx.gbl...

Hi,

My advise is you to read about bind in windows forms, google: windows forms data bind

You need to especify the table from where the columns will come from, I got this piece of code from the first link in the above search

private DataViewManager dsView;
private DataSet ds;

dsView = ds.DefaultViewManager;

// Combobox Databinding
cbCust.DataSource = dsView;
cbCust.DisplayMember = "Customers.CompanyName";
cbCust.ValueMember = "Customers.CustomerID";

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Lasse Edsvik" <la***@nospam.com> wrote in message
news:ek*************@TK2MSFTNGP15.phx.gbl...

Hello

I've created a class that has a method that returns a dataset like this:

public DataSet GetAllCustomers()

{

Open();

DataSet ds = new DataSet();

SqlDataAdapter da = new SqlDataAdapter();

da.SelectCommand = new SqlCommand("CustListAll", dbconn);

da.Fill(ds);

return ds;

}

Then I added a new project and then tried to do this:

public Form1()

{

InitializeComponent();

Northwind n = new Northwind();

listBox1.DataSource = n.GetAllCustomers();

listBox1.DisplayMember = "CustomerName";

listBox1.Text = "CustomerName";

}

When I run it only has a text
"System.Data.DataViewManagerListItemType.Descripto r" in it

errrm? :) what to do here to get it to show in listbox?

/Lasse

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Did you put the other lines?
even as you only have one table you may get need to indicate which table the
columns refer to

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Lasse Edsvik" <la***@nospam.com> wrote in message
news:Oh*************@TK2MSFTNGP10.phx.gbl...

hmm k,

changing to:

listBox1.DataSource = n.GetAllCustomers().DefaultViewManager;

didnt help much either :(

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us>
wrote
in message news:uW**************@TK2MSFTNGP15.phx.gbl...

Hi,

My advise is you to read about bind in windows forms, google: windows

forms

data bind

You need to especify the table from where the columns will come from, I

got

this piece of code from the first link in the above search

private DataViewManager dsView;
private DataSet ds;

dsView = ds.DefaultViewManager;

// Combobox Databinding
cbCust.DataSource = dsView;
cbCust.DisplayMember = "Customers.CompanyName";
cbCust.ValueMember = "Customers.CustomerID";

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Lasse Edsvik" <la***@nospam.com> wrote in message
news:ek*************@TK2MSFTNGP15.phx.gbl...

> Hello
>
> I've created a class that has a method that returns a dataset like
> this:
>
> public DataSet GetAllCustomers()
>
> {
>
> Open();
>
> DataSet ds = new DataSet();
>
> SqlDataAdapter da = new SqlDataAdapter();
>
> da.SelectCommand = new SqlCommand("CustListAll", dbconn);
>
> da.Fill(ds);
>
> return ds;
>
> }
>
>
>
> Then I added a new project and then tried to do this:
>
>
>
> public Form1()
>
> {
>
> InitializeComponent();
>
> Northwind n = new Northwind();
>
> listBox1.DataSource = n.GetAllCustomers();
>
> listBox1.DisplayMember = "CustomerName";
>
> listBox1.Text = "CustomerName";
>
>
>
> }
>
>
>
> When I run it only has a text
> "System.Data.DataViewManagerListItemType.Descripto r" in it
>
> errrm? :) what to do here to get it to show in listbox?
>
>
>
> /Lasse
>
>
>
>