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

Karthik K

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.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo8y ago
sir
only do
grdCart.DataSource = null
Karthik K8y ago
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 Sahoo8y ago
sir
Clear your sesion like Session["DishCart"] = null;
and also grdCart.DataSource = null
Gautam Parmar8y ago
you can transfer your current temp data to newly generated session cart, and the once session generates delete from current temp table
Karthik K8y ago
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 Parmar8y ago
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)