Click here to Skip to main content
15,891,033 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have problem to rebind data after updating pls can u help how to solve?
I have problem to rebind without updating...
.aspx

ASP.NET
<asp:TemplateField HeaderText="Vendor Code">
          <itemtemplate>
              <%# Eval("VendorCode")%>
          </itemtemplate>
          <edititemtemplate>
              <asp:DropDownList runat="server" ID="ddlVendorCode" DataTextField="VendorCode" DataValueField="VendorCode" SelectedValue='<%# Bind("VendorCode", "{0}") %>' >
              
          </edititemtemplate>
          <controlstyle width="150px" />
          <itemstyle width="150px" />




.aspx.cs



C#
protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            BindDataToGrid();
                }
    }

void BindDataToGrid()
    {
        Class1 cls = new Class1(Session["sdbpath"].ToString());
        cls.con.Open();
        string qry = "select * from tblPerson";
        DataTable dt = cls.GridDataTable(qry);
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        
        GridViewRow row = GridView1.Rows[e.RowIndex];

        TextBox txtPersonID = (TextBox)row.FindControl("txtPersonID");
 
        DropDownList ddlVendorCode =
        (DropDownList)row.FindControl("ddlVendorCode");

        TextBox txtPersonName = (TextBox)row.FindControl("txtPersonName");
        TextBox txtAddress = (TextBox)row.FindControl("txtAddress");
        TextBox txtContact = (TextBox)row.FindControl("txtContact");
        TextBox txtDesignation = (TextBox)row.FindControl("txtDesignation");
        TextBox txtEmail = (TextBox)row.FindControl("txtEmail");
        
        String PersonID = GridView1.DataKeys[e.RowIndex].Value.ToString();
        string VendorCode = ddlVendorCode.SelectedItem.ToString();
        string PersonName = txtPersonName.Text;
        string Address = txtAddress.Text;
        string Contact = txtContact.Text;
        string Designation = txtDesignation.Text;
        string Email = txtEmail.Text;
  
        Class1 cls1 = new Class1(Session["sdbpath"].ToString());//connectio class define
        cls1.con.Open();
        string qry = "update tblPerson set VendorCode = '" + ddlVendorCode.SelectedItem.ToString() +"' ,PersonName = '" + txtPersonName.Text + "' ,Address = '" + txtAddress.Text + "' ,Contact='" + txtContact.Text + "' ,Designation='" + txtDesignation.Text + "' ,Email='" + txtEmail.Text + "' where PersonID = '" + PersonID + "'";
        cls1.SaveEditDeleteData(qry);

        string msg = "alert('Person information has been Upated sucessfully ');";
        Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", msg, true);

        GridView1.EditIndex = -1;
        BindDataToGrid();
    }
Posted
Updated 17-Feb-13 21:11pm
v2

My suggestion you must bind Dropdownlist at RowDataBound event.
 
Share this answer
 
please bind your dropdownlist on rowdatabound event of gridview
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900