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

Question

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'v 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:

Any suggestion?

thanks, liron

Solution 1

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();

Solution 2

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.