want to clear the cartlist in asp.net ?..

Question

Hi all  I want to clear the carlist  which I loaded from the order page. Those values to be generated from temporary datatable. I have confirmed it in Cofirm.aspx Page I have created Session for that tempory table. After saving the Cartlist. I have clear that Session. I share my code ..Anybody know it . Suggest me to do so . protected void Page_Load( object sender EventArgs e) { DishCart_DataTable = new DataTable(); DishCart_DataTable.Columns.Add( DishId ); DishCart_DataTable.Columns.Add( ImagePath ); DishCart_DataTable.Columns.Add( DishName ); DishCart_DataTable.Columns.Add( Price ); DishCart_DataTable.Columns.Add( Count ); DishCart_DataTable.Columns.Add( Total ); DishCart_DataTable = (DataTable)Session[ DishCart ]; grdCart.DataSource = DishCart_DataTable; grdCart.DataBind(); if (!IsPostBack) { LoadNum(); } This how I load the Grid . Now i need it to be clear after saving it to database. How can I null session of datatable values.

Laxmidhar Sahoo · Answer

sir only do grdCart.DataSource = null

Karthik Che · Answer

Hi Gautham I couldnt understand what you meant. protected void Page_Load(object sender EventArgs e) { DishCart_DataTable = new DataTable(); DishCart_DataTable.Columns.Add(DishId); DishCart_DataTable.Columns.Add(ImagePath); DishCart_DataTable.Columns.Add(DishName); DishCart_DataTable.Columns.Add(Price); DishCart_DataTable.Columns.Add(Count); DishCart_DataTable.Columns.Add(Total); DishCart_DataTable = (DataTable)Session[DishCart]; grdCart.DataSource = DishCart_DataTable; grdCart.DataBind(); if (!IsPostBack) { LoadNum(); } } button click on ConfirmCart.aspx Page : protected void btnChceckOut_Click(object sender EventArgs e) { Customer_Det(); SaveOrderHead(); ScriptManager.RegisterStartupScript(Page Page.GetType() err_msg alert('Your Order Has been Placed ! Your OrderId :  + ObjPL.OrderCode + ') true); grdCart.DataSource = null; grdCart.DataBind(); Session[DishCart] = null; Server.Transfer(Index.aspx); //Response.Write( ); //this.ClientScript.RegisterClientScriptBlock(this.GetType() Close window.close() true); } Here only : how should i null the session and i want go back to index.aspx page Thanks in Advance  Karthik.k

Laxmidhar Sahoo · Answer

sir Clear your sesion like Session[DishCart] = null; and also grdCart.DataSource = null

Gautam Parmar · Answer

you can transfer your current temp data to newly generated session cart and the once session generates delete from current temp table

Karthik Che · Answer

Hi Gautham  I have using session for it . i coludnt understand of you concept .can explain it ?.. if i clear session that is enough right?..

Gautam Parmar · Answer

You can give foreign key to primary key between temp table and final table And into cart temp table load data like Select * from tempTable where Primarykeyid is not in ( select PrimarykeyId from FinalTable)