Put DataList into Session Object

Question

Hi I have a DataList that is getting rows from a table and filling my DataList. When my user leaves my page, I want to hold this DataList in Session and show it again if/when the user returns to the page. I created a function that creates a new DataTable, and stores my DataList dataTable in, then I assigned it to a Session object. But I cannot get it to show the list again when the user revisits the page. I checked the debugger and my columns are there in my second dataTablebut, It is not displaying. Here is my code. Can someone make sure it is functional. Thank you very much.

//my method to create a new DataTable and store the DataList rows.
protected DataTable CreateHeathCenterAddressTable(DataTable tableSchema)
    {
        DataTable tableAddressData = new DataTable();

    foreach (DataColumn dc in tableSchema.Columns)
        {
            tableAddressData.Columns.Add(dc.ColumnName,
                  dc.DataType);
        }
        return tableAddressData;

    }

//then I'm calling the original data from my database and passing that DataTable into my function.

SqlDataAdapter SQLDataAdapter = new SqlDataAdapter(prcLocationListByGeography);
            DataTable dtViewResult = new DataTable();
            SQLDataAdapter.Fill(dtViewResult);
            healthCenters.DataSource = dtViewResult;
            healthCenters.DataBind();
            SQLDataAdapter.Dispose();
            con.Close();
            DataTable tableAddressItems = CreateHeathCenterAddressTable(dtViewResult);//here I'm calling my method and passing in the dtViewResult
            Session["tableAddressItems"] = tableAddressItems;

        }

//on the page load I'm doing this
if(Session["tableAddressItems"] != null)
{
    healthCenters.DataSource = Session["tableAddressItems"];
    healthCenters.DataBind();

}
//I set a trace on the page, and my DataTable is getting held in Session??

Jignesh Trivedi · Answer

hi try following code DataTable tableAddressItems = Session[tableAddressItems] as DataTable; healthCenters.DataSource = tableAddressItems; healthCenters.DataBind(); hope this will help you.

mark fisher · Answer

Hi! This did not work. I have a DataList that could potentially have one of two DataSources depending on the user input. I need to get the DataLists values into Session object and tehn if the user goes back to that page I want to check to make sure the Session var is not null and check which Session object to load into the DataList. //I have this dataSource feeding the table if user selects one option: //...some database code.... DataTable dtZipResult = new DataTable(); SQLDataAdapter.Fill(dtZipResult); healthCenters.DataSource = dtZipResult; healthCenters.DataBind(); SQLDataAdapter.Dispose(); con.Close(); //and if the user makes another selection I load the DataList with this //...some database call... DataTable dtViewResult = new DataTable(); SQLDataAdapter.Fill(dtViewResult); healthCenters.DataSource = dtViewResult; healthCenters.DataBind(); SQLDataAdapter.Dispose(); con.Close(); I want to put these into Session objects and when the page loads again after the user returns load the DataList again. I have had no luck getting my List to load.