DropDown Vlaues are Changed when delete a record in GridView

Question

4.00/5 (1 vote)

See more:

I have a Gridview ,in that one of the Column is DropDownList .I have 10 Records in my Grid and my DropDown Values are like this 1,2,3....10.This is the format to store my DropDown values ,if i delete 4th Row ,then my DropDown Values are Changed like 1,2,3,4....9.This is my task ,but i'm getting this format 1,2,3,--,5...10.Any one Can help me to do this .I wrote code like this

This is Remove Button Code:

C#

protected void btnToRemove_OnClick(object sender, EventArgs e)
        {
            EIPEDMS objEDMS = new EIPEDMS();
            string Result = "";

            DataTable dtTo = ViewState["PAM"] as DataTable;

            foreach (GridViewRow gvrTo in gvTo.Rows)
            {
                CheckBox chkSelect = gvrTo.FindControl("chkSelect") as CheckBox;

                if (chkSelect.Checked == true)
                {
                    Label lblMember_Id = gvrTo.FindControl("lblMember_Id") as Label;

                    Result = objEDMS.Delete_Project_Alert_Members(ddlProject.SelectedValue, lblMember_Id.Text, Member);

                }
            }
            DataSet dsPAM = objEDMS.Get_Project_Alert_Member(ddlProject.SelectedValue);
            dtTo = dsPAM.Tables[0];
            ViewState["PAM"] = dtTo;

            DataView dvTo = dtTo.DefaultView;
            dvTo.RowFilter = "Receiver_Type=2";

            gvTo.DataSource = dvTo;
            gvTo.DataBind();

            for (int i = 0; i < gvTo.Rows.Count; i++)
            {
                dtTo = dvTo.ToTable();
                DropDownList ddl = (DropDownList)gvTo.Rows[i].FindControl("ddlSortTo");
                ddl.SelectedValue = dtTo.Rows[i]["Sort_By"].ToString();

            }
        }

This is DataBound Code:

C#

protected void gvTo_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                EIPEDMS objEDMS = new EIPEDMS();

                DataTable dtTo = ViewState["PAM"] as DataTable;
                                
                DataView dvTo = dtTo.DefaultView;

                dvTo.RowFilter = "Receiver_Type=2";

                DropDownList ddlSortTo = (DropDownList)e.Row.Cells[2].FindControl("ddlSortTo");
                


                ddlSortTo.DataSource = dvTo;

                ddlSortTo.DataTextField = "Sort_By_Dup";
                ddlSortTo.DataValueField = "Sort_By_Dup";

                ddlSortTo.DataBind();

            }
        }

This is Selected?IndexChanged Event Code:

C#

protected void ddlSortTo_OnSelectedIndexChanged(object sender, EventArgs e)
        {
            EIPEDMS objEDMS = new EIPEDMS();

            DataTable dtTo = ViewState["PAM"] as DataTable;


            DataView dvTo = dtTo.DefaultView;
            dvTo.RowFilter = "Receiver_Type=2";

            DataTable dt = new DataTable();


            dt = dvTo.ToTable();
            DropDownList ddl1 = sender as DropDownList;
            foreach (GridViewRow myRow in gvTo.Rows)
            {
                DropDownList ddl = myRow.FindControl("ddlSortTo") as DropDownList;
                if (ddl.ClientID == ddl1.ClientID)
                {

                    Label lblMember_Id = myRow.FindControl("lblMember_Id") as Label;
                    lblMember_Id.Text = ddl1.SelectedValue;
                    int index = myRow.RowIndex;//Convert.ToInt32(lblMember_Id.Text);
                    dt.Rows[index]["Sort_By"] = lblMember_Id.Text;


                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        if (dt.Rows[i][3] != dt.Rows[i][4])
                        {
                            if (Convert.ToInt32(dt.Rows[i][3]) < Convert.ToInt32(dt.Rows[i][4]))
                            {
                                int val = Convert.ToInt32(dt.Rows[i][3]);

                                do
                                {
                                    for (int j = 0; j < dt.Rows.Count; j++)
                                    {
                                        if (val == Convert.ToInt32(dt.Rows[j][4]) && val < Convert.ToInt32(dt.Rows[i][4]))
                                        {
                                            val = val + 1;
                                            dt.Rows[j][4] = val;
                                        }
                                        if (val == j + 1)
                                        {
                                            dt.Rows[j][4] = dt.Rows[j][3];
                                        }
                                    }

                                    val++;
                                }
                                while (val < Convert.ToInt32(dt.Rows[i][4]));
                            }

                            else if (Convert.ToInt32(dt.Rows[i][3]) > Convert.ToInt32(dt.Rows[i][4]))
                            {
                                int val = Convert.ToInt32(dt.Rows[i][3]);

                                for (int j = val - 1; j >= 0; j--)
                                {
                                    if (val == Convert.ToInt32(dt.Rows[j][4]) && val > Convert.ToInt32(dt.Rows[i][4]))
                                    {
                                        val = val - 1;
                                        dt.Rows[j][4] = val;
                                    }
                                    if (val == j + 1)
                                    {
                                        dt.Rows[j][4] = dt.Rows[j][3];
                                    }
                                    dt.Rows[j][3] = dt.Rows[j][4];
                                   
                                }
                            }
                        }
                    }
                    dt.AcceptChanges();
                    for (int i = 0; i < dtTo.Rows.Count; i++)
                    {
                        for (int j = 0; j < dt.Rows.Count; j++)
                        {
                            if (Convert.ToInt32(dtTo.Rows[i][0]) != Convert.ToInt32(dt.Rows[j][0]))
                            {
                                dtTo.Rows[j][4] = dt.Rows[j][4];
                            }

                        }
                    }
                    
                    break;
                }
            }
            //DataSet dsPAM = objEDMS.Get_Project_Alert_Member(ddlProject.SelectedValue);
            //dt= dsPAM.Tables[0];

            ViewState["PAM"] = dtTo;

            gvTo.DataSource = dt;
            gvTo.DataBind();
                        
            //gvTo.Sort("Sort_By_Dup", SortDirection.Ascending);

            for (int i = 0; i < gvTo.Rows.Count; i++)
            {

                DropDownList ddlTo = (DropDownList)gvTo.Rows[i].FindControl("ddlSortTo");
                ddlTo.SelectedValue = dt.Rows[i][4].ToString();

            }
        }

Posted 6-Aug-12 0:45am

naveensanagasetti

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2012-08-06T01:44:00

I guess the problem is in the following line

C#

ddl.SelectedValue = dtTo.Rows[i]["Sort_By"].ToString();

Because the Sort_By Row gets updated each time you delete a row and for a deleted row it will not exist.
So, if you will assign that value, it will obviously give blank value to the dropdown selection.

You also need to update the value in the viewstate in order to reflect the changes.
When you delete the 4th row, at that time, if you can update the value of the dropdowns in viewstate according to the row number, then it will give you what you want. Try it out...

All the best...
Thanks...