CODEWITHSUNDEEP
c#asp.netlistboxdatatable
liron
liron

Reputation: 121

How to bind a ListBox to a DataTable from a session object?

I have a session object that contains a DataTable from my previous page, and i would like to bind this DataTable to a ListBox.

I've done this:

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        if (Session["bestStocks"] !=null)
        {
            DataTable dt = new DataTable();
           

            dt = (DataTable)Session["bestStocks"];

            DataView dv = new DataView(dt);
            BestStockslb.DataSource = dt;
            BestStockslb.DataBind();
        }
     }
 }

I get this result:

enter image description here

Any suggestion?

Upvotes: 3

Views: 11833

Answers (2)

Kev Ritchie
Kev Ritchie

Reputation: 1647

Change this line:

BestStockslb.DataSource = dt;

To:

BestStockslb.DataSource = dt.DefaultView;

And you also need to set the DataTextField and DataValueField Properties of BestStockslb to link to the required fields in the returned data. This is why you are getting the DataRowView output.

You could also remove DataView dv = new DataView(dt); as it looks like you are not using it.

Upvotes: 2

Ashfaq Shaikh
Ashfaq Shaikh

Reputation: 1668

It seems you have forgot the DataTextField and DataValueField 

 dt = (DataTable)Session["bestStocks"];

DataView dv = new DataView(dt);
BestStockslb.DataSource = dt;
BestStockslb.DataTextField =  "Name";
BestStockslb.DataValueField =  "ID"; 
BestStockslb.DataBind();

Upvotes: 3

Related Questions