<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" />
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(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)