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.

Answer 1

sir

only do

grdCart.DataSource = null

Answer 2

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("<!-- Inject Script Filtered -->");

//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

Answer 3

sir

Clear your sesion like Session["DishCart"] = null;

and also grdCart.DataSource = null

Answer 4

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

Answer 5

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?..

 

  

Answer 6

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)