Hi frends i want to delete recorde from gridview but that data is store in database i am using session .
This is an shopping cart project once i select product that product stored in dictionary using session i passed that data to mycart page & bound session with gridview .
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) {
try {
//new ProductContext(ConfigurationManager.ConnectionStrings["ShoppingDBConnectionString"].ConnectionString).
// DeleteProduct(Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values["ProductId"].ToString()));
new ProductContext(ConfigurationManager.ConnectionStrings["ShoppingDBConnectionString"].ConnectionString).
DeleteProduct(int.Parse(GridView1.DataKeys[e.RowIndex].Values["ProductId"].ToString()));
GridView1.EditIndex = -1;
GridView1.DataBind();
} catch (Exception ex) {
throw ex;
}
This is give me error please suggesr how to resolve my problem my source code is given belowProductdetail.aspx
<%@ Page Title="" Language="C#" MasterPageFile="~/ShoppingApp.Master" AutoEventWireup="true" CodeBehind="ProductDetails.aspx.cs" Inherits="ShoppingCart.ProductDetails" %>
DataKeyField="ProductId" DataSourceID="SqlDataSource1" ForeColor="#333333"> ProductId: CatalogId: ProductName: Text='<%# Eval("ProductName") %>' /> UnitPrice: Discription: Text='<%# Eval("Discription") %>' /> RealeseDate: Text='<%# Eval("RealeseDate") %>' /> ImageUrl: ConnectionString="<%$ ConnectionStrings:ShoppingDBConnectionString %>" SelectCommand="SELECT [ProductId], [CatalogId], [ProductName], [UnitPrice], [Discription], [RealeseDate], [ImageUrl] FROM [Product] WHERE ([ProductId]=@ProductId)"> QueryStringField="ProductId" Type="Decimal" /> onclick="btnAdd_Click"/> |
productdetailaxpx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using ShoppingCart.SQL;
using System.Configuration;
using System.Data;
using System.Collections;
namespace ShoppingCart {
public partial class ProductDetails : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
}
protected void btnAdd_Click(object sender, EventArgs e) {
try {
//Using Dictionary
if (Session["MyCartItems"] == null) {
//no items exist in the cart
//hence we need to create the array list in the session
Dictionary cart = new Dictionary();
cart.Add(int.Parse(Request.QueryString["ProductId"].ToString()),
int.Parse(txtquantity.Text));
Session["MyCartItems"] = cart;
} else {
//some items exist already in the session
//hence append items to it
Dictionary cart = (Dictionary)Session["MyCartItems"];
if(cart.ContainsKey(int.Parse(Request.QueryString["ProductId"].ToString()))){
cart[int.Parse(Request.QueryString["ProductId"].ToString())] = int.Parse(txtquantity.Text.Trim());
}else{
cart.Add(int.Parse(Request.QueryString["ProductId"].ToString()),
int.Parse(txtquantity.Text));
}
Session["MyCartItems"] = cart;
}
Response.Redirect("MyCart.aspx");
} catch (Exception ex) {
throw ex;
}
}
}
}
mycart.aspx
Back To Home
mycartaspx.cs
Thanks Lots..................
<%@ Page Title="" Language="C#" MasterPageFile="~/ShoppingApp.Master" AutoEventWireup="true" CodeBehind="MyCart.aspx.cs" Inherits="ShoppingCart.MyCart" %>
BorderColor="#660033" BorderStyle="None" BorderWidth="1px" CellPadding="3"
CellSpacing="2" Width="439px"
ForeColor="White" ShowFooter="true"
onrowdatabound="GridView1_RowDataBound">
ConnectionString="<%$ ConnectionStrings:ShoppingDBConnectionString %>"
SelectCommand="SELECT [ProductId],[ProductName],[UnitPrice],[Discription] FROM [Product] WHERE ([ProductId]=@ProductId)">
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using ShoppingCart.SQL;
using System.Configuration;
using System.Data;
using System.Collections;
namespace ShoppingCart {
public partial class MyCart : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
if (!IsPostBack)
Bind();
}
public void Bind() {
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("ProductId", typeof(int)));
dt.Columns.Add(new DataColumn("Quantity", typeof(int)));
dt.Columns.Add(new DataColumn("ProductName", typeof(string)));
dt.Columns.Add(new DataColumn("UnitPrice", typeof(int)));
dt.Columns.Add(new DataColumn("Discription", typeof(string)));
dt.Columns.Add(new DataColumn("Total",typeof(int)));
if (Session["MyCartItems"] != null) {
Dictionary cart = (Dictionary)Session["MyCartItems"];
foreach (KeyValuePair kvp in cart) {
//kvp.Key
//kvp.Value
DataRow dr = dt.NewRow();
//int ProductId = kvp.Key;
//int Quantity = kvp.Value;
dr = new ProductContext(ConfigurationManager.ConnectionStrings["ShoppingDBConnectionString"].ToString()).
GetProductSummaryByProductId(kvp.Key,kvp.Value,dr);
dt.Rows.Add(dr);
}
} else {
//show an empty cart
}
GridView1.DataSource =dt;
GridView1.DataBind();
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) {
decimal GrandTotal=0;
if (e.Row.RowType == DataControlRowType.DataRow){
GrandTotal += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Total"));
}
if (e.Row.RowType == DataControlRowType.DataRow) {
decimal currentTotal = decimal.Parse(hdnGrandTotal.Value);
currentTotal += Convert.ToDecimal(e.Row.Cells[5].Text);
hdnGrandTotal.Value=currentTotal.ToString();
} else if (e.Row.RowType == DataControlRowType.Footer) {
e.Row.Cells[2].Text = "Total:";
e.Row.Cells[5].Text = hdnGrandTotal.Value.ToString();
e.Row.Font.Bold = true;
}
}
}
}
Muhammad younasPosted Apr 1, 2011, 1:26 AM
i cant understand ur problem
r u want to delete data from gridview without deleting it from database .am i right???????