I have problem to rebind data after updating pls can u help how to solve?
I have problem to rebind without updating...
.aspx
<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
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());
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();
}