Updating Items in GridView through Code

Question

I have a GV in which I want to Update my items. I am not using LDS or anything coz I m updating items which are stored in multiple databases.

Here is the markup of my GV:

And here is code I've been trying but I cant able to get the updated TEXT in my 's' variable:

    protected void Page_Load(object sender, EventArgs e)
    {

        if (Session["EntitySelected"] == null)
        {
            MessageBox.Show("Please Select an Entity first!");
            Response.Redirect("~/FrontEnd/AgentList.aspx");
        }

        int getEntity = Int16.Parse(Session["EntitySelected"].ToString());
        this.Label3.Text = "You Selected Entity: " + (string)Session["EntitySelected"];

        dbWebEnrollDataContext dt1 = new dbWebEnrollDataContext(); //This has PlanName!
        CommissionsV2DataContext cv1 = new CommissionsV2DataContext(); //Entity_Product_Point
        var td = from s in GetEntity()
                 join r in GetPlanName() on s.Product_ID equals r.Product_ID
                 where s.Entity_ID == getEntity
                 select new
                 {
                     s.Product_ID,
                     r.PlanName,
                     s.HiCommissionOld,
                     s.LowCommissionOld


                 };
        gvShowComm.DataSource = td;
        gvShowComm.DataBind();
    }

    static IEnumerable GetEntity()
    {
        var context = new CommissionsV2DataContext();
        return (from t in context.Entity_Product_Points select t).AsQueryable();
    }

    static IEnumerable GetPlanName()
    {
        var context = new dbWebEnrollDataContext();
        return (from t in context.PlanMasters select t).AsQueryable();
    }

    protected void btnAdd_Click(object sender, EventArgs e)
    {


            if (ddlPlan.SelectedValue != null && tb1stYr.Text != "" && tbMaximum.Text != "" && tbRecurring.Text != "")
            {
                //Accessing Variables and defining them.
                using (dbWebEnrollDataContext dt = new dbWebEnrollDataContext())
                    try
                    {
                        int getEntity = Int16.Parse(Session["EntitySelected"].ToString());

                        var productName = ddlPlan.SelectedValue.ToString();

                        decimal firststYrComp = Int16.Parse(tb1stYr.Text.ToString());
                        decimal recurringComp = Int16.Parse(tbRecurring.Text.ToString());
                        decimal maximumPercent = Int16.Parse(tbMaximum.Text.ToString());

                        //Pulling the Product_ID from the PlanMaster Table from WebEnroll DB!

                        //var tr = dt.PlanMasters.First(s => s.PlanName == productName);

                        var tr = from s in dt.PlanMasters
                                 where s.PlanName == productName
                                 select s.Product_ID;

                        decimal finalFirstYrComp = decimal.Round((firststYrComp / maximumPercent), 3);
                        decimal finalRecurringComp = decimal.Round((recurringComp / maximumPercent), 3);

                        //Updating the Table: Entity_Product_Points in CommissionsV2 DB.
                        CommissionsV2DataContext cv = new CommissionsV2DataContext();
                        Entity_Product_Point ev = new Entity_Product_Point();
                        ev.Entity_ID = getEntity;
                        ev.Product_ID = tr.First();
                        ev.HiCommissionOld = (double)firststYrComp;
                        ev.LowCommissionOld = (double)recurringComp;
                        ev.HiCommission = (double)finalFirstYrComp * 100;
                        ev.LowCommission = (double)finalRecurringComp * 100;
                        ev.DateCreated = System.DateTime.Now;
                        cv.Entity_Product_Points.InsertOnSubmit(ev);
                        cv.SubmitChanges();

                        var td = from s in GetEntity()
                                 join r in GetPlanName() on s.Product_ID equals r.Product_ID
                                 where s.Entity_ID == getEntity
                                 select new
                                 {
                                     s.Product_ID,
                                     r.PlanName,
                                     s.HiCommissionOld,
                                     s.LowCommissionOld


                                 };

                        gvShowComm.DataSource = td;
                        gvShowComm.DataBind();

                    }

                    catch (Exception err)
                    {
                        MessageBox.Show("" + err);
                    }
            }

            else
            {
                MessageBox.Show("Please Enter Entry for the textboxes!");
            }

            tb1stYr.Text = "";
            tbMaximum.Text = "";
            tbRecurring.Text = "";
            ddlPlan.SelectedIndex = 0;
        }


    protected void gvShowComm_RowEditing(object sender, GridViewEditEventArgs e) 
    {
        gvShowComm.EditIndex = e.NewEditIndex;
        gvShowComm.DataBind();

    }

    protected void gvShowComm_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        gvShowComm.EditIndex = -1;
        gvShowComm.DataBind();
    }

    protected void gvShowComm_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        System.Web.UI.WebControls.TextBox myBox = gvShowComm.Rows[e.RowIndex].FindControl("PlanName") as System.Web.UI.WebControls.TextBox;
        string s = myBox.Text;
        gvShowComm.DataBind();
    }



    }

Joe Schrag · Accepted Answer

Two ideas: First, you can use Template Fields for your columns & name the control holding your data. The contents of those controls can then be retrieved as follows: ((TextBox)e.Row.FindControl("TextBoxProductName")).Text

The template would look something like this:

Note also that because you are databinding the gridview manually, in the RowEditing (Not the RowUpdating) event fired by the edit button, you must set the gridview's edit index. Try:

gvShowComm.EditIndex = e.Row.RowIndex;

Or, second, you can have more than one datakey in a gridview. Try something like: DataKeyNames="Product_ID,Product_Name,Product_Price"

Those values can then be retrieved as follows:

gvShowComm.DataKeys[e.RowIndex]["Product_Name"]

I should note that DataKeys are only really designed to hold db primary keys. Using them for anything else is a hack. That said, I've had need for it occasionally when I need to store some piece of information for each row, but I don't want it visible to the user.

A final note, don't put the databinding in the page load unless you are putting it inside a conditional that only fires on initial page load, not every postback. Ex: if(!IsPostback) ...

Updating Items in GridView through Code

Answers (2)

Related Questions