How to create custom editing on grid view in Asp.net

Question

How to create custom editing on grid view in Asp.net.

Akkiraju Ivaturi · Answer

Find my code here: ASP.NET Code: language=C# masterpagefile=~/MasterPages/Default.master title=GridView: MY example %> autogeneratecolumns=False datakeynames=ShipperID emptydatatext=There are no data records to display. onpageindexchanging=gvShippers_PageIndexChanging onrowcancelingedit=gvShippers_RowCancelingEdit onrowcommand=gvShippers_RowCommand onrowdeleting=gvShippers_RowDeleting onrowediting=gvShippers_RowEditing onrowupdating=gvShippers_RowUpdating onsorting=gvShippers_Sorting showfooter=true style=margin-top: 20px;> readonly=true sortexpression=ShipperID /> ' /> ' /> Code Behind file: using System; using System.Collections; using System.Collections.Generic; using System.Collections.Specialized; using System.Configuration; using System.Data; using System.Data.SqlClient; using System.Web.UI; using System.Web.UI.WebControls; public partial class GridView_MyExample : System.Web.UI.Page { private string Sort { get { return String.Concat( this.SortExpression (this.SortDirection == SortDirection.Ascending) ?  ASC :  DESC); } } private SortDirection SortDirection { get { if (ViewState[SortDirection] == null) { ViewState[SortDirection] = SortDirection.Ascending; } return (SortDirection)ViewState[SortDirection]; } set { ViewState[SortDirection] = value; } } private string SortExpression { get { if (ViewState[SortExpression] == null) { ViewState[SortExpression] = ShipperID; } return ViewState[SortExpression].ToString(); } set { ViewState[SortExpression] = value; } } private IDictionary GetValues(GridViewRow row) { IOrderedDictionary dictionary = new OrderedDictionary(); foreach (Control control in row.Controls) { DataControlFieldCell cell = control as DataControlFieldCell; if ((cell != null) && cell.Visible) { cell.ContainingField.ExtractValuesFromCell(dictionary cell row.RowState true); } } IDictionary values = new Dictionary (); foreach (DictionaryEntry de in dictionary) { values[de.Key.ToString()] = de.Value; } return values; } private void SetData() { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[NorthwindConnectionString].ConnectionString)) using (SqlCommand cmd = new SqlCommand(SELECT * FROM [Shippers] conn)) using (SqlDataAdapter adapter = new SqlDataAdapter(cmd)) { try { conn.Open(); DataTable dt = new DataTable(); adapter.Fill(dt); DataView dv = dt.DefaultView; dv.Sort = this.Sort; gvShippers.DataSource = dv; gvShippers.DataBind(); } catch{} } } protected void Page_Load(object sender EventArgs e) { if (!this.IsPostBack) { this.SetData(); } } protected void gvShippers_PageIndexChanging(object sender GridViewPageEventArgs e) { gvShippers.PageIndex = e.NewPageIndex; this.SetData(); } protected void gvShippers_Sorting(object sender GridViewSortEventArgs e) { if (this.SortExpression.Equals(e.SortExpression)) { this.SortDirection = (this.SortDirection == SortDirection.Ascending) ? SortDirection.Descending : SortDirection.Ascending; } else { this.SortDirection = SortDirection.Ascending; } this.SortExpression = e.SortExpression; this.SetData(); } protected void gvShippers_RowEditing(object sender GridViewEditEventArgs e) { gvShippers.EditIndex = e.NewEditIndex; this.SetData(); } protected void gvShippers_RowCancelingEdit(object sender GridViewCancelEditEventArgs e) { gvShippers.EditIndex = -1; this.SetData(); } protected void gvShippers_RowUpdating(object sender GridViewUpdateEventArgs e) { GridViewRow row = gvShippers.Rows[e.RowIndex]; var newValues = this.GetValues(row); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[NorthwindConnectionString].ConnectionString)) using (SqlCommand cmd = new SqlCommand(UPDATE [Shippers] SET [CompanyName] = @CompanyName [Phone] = @Phone WHERE (ShipperID = @ShipperID) conn)) { cmd.Parameters.AddWithValue(ShipperID gvShippers.DataKeys[row.RowIndex][ShipperID]); cmd.Parameters.AddWithValue(CompanyName newValues[CompanyName]); cmd.Parameters.AddWithValue(Phone newValues[Phone]); try { conn.Open(); if (cmd.ExecuteNonQuery().Equals(1)) { lblMessage.Text = String.Format( Shipper '{0}' successfully updated. cmd.Parameters[ShipperID].Value); gvShippers.EditIndex = -1; this.SetData(); } } catch {} } } protected void gvShippers_RowDeleting(object sender GridViewDeleteEventArgs e) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[NorthwindConnectionString].ConnectionString)) using (SqlCommand cmd = new SqlCommand(DELETE FROM [Shippers] WHERE (ShipperID = @ShipperID) conn)) { cmd.Parameters.AddWithValue(ShipperID gvShippers.DataKeys[e.RowIndex][ShipperID]); try { conn.Open(); if (cmd.ExecuteNonQuery().Equals(1)) { lblMessage.Text = String.Format( Shipper '{0}' successfully deleted. cmd.Parameters[ShipperID].Value); this.SetData(); } } catch {} } } protected void gvShippers_RowCommand(object sender GridViewCommandEventArgs e) { if (e.CommandName.Equals(Insert)) { LinkButton btnInsert = e.CommandSource as LinkButton; if (btnInsert == null) { return; } GridViewRow row = btnInsert.NamingContainer as GridViewRow; TextBox txtCompanyName = row.FindControl(txtCompanyName) as TextBox; TextBox txtPhone = row.FindControl(txtPhone) as TextBox; if (txtCompanyName == null) { return; } if (txtPhone == null) { return; } using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[NorthwindConnectionString].ConnectionString)) using (SqlCommand cmd = new SqlCommand(INSERT INTO [Shippers] ([CompanyName] [Phone]) VALUES (@CompanyName @Phone); SELECT @ShipperID = SCOPE_IDENTITY() conn)) { cmd.Parameters.AddWithValue(CompanyName txtCompanyName.Text); cmd.Parameters.AddWithValue(Phone txtPhone.Text); cmd.Parameters.Add(ShipperID SqlDbType.Int); cmd.Parameters[ShipperID].Direction = ParameterDirection.Output; try { conn.Open(); if (cmd.ExecuteNonQuery().Equals(1)) { lblMessage.Text = String.Format( Shipper '{0}' successfully added. cmd.Parameters[ShipperID].Value); this.SetData(); } } catch {} } } } }

Satyapriya Nayak · Answer

Hi Prabhakar Untitled Page DataKeyNames=VendorId AllowPaging=True CellPadding=3 OnPageIndexChanging=ResultGridView_PageIndexChanging OnRowDeleting=ResultGridView_RowDeleting OnRowEditing=ResultGridView_RowEditing OnRowUpdating=ResultGridView_RowUpdating OnRowCancelingEdit=ResultGridView_RowCancelingEdit PageSize=5 BackColor=#DEBA84 BorderColor=#DEBA84 BorderStyle=None BorderWidth=1px CellSpacing=2 OnRowCommand=ResultGridView_RowCommand AllowSorting=true onsorting=ResultGridView_Sorting> ReadOnly=True SortExpression=VendorId /> '> '> '> '> '> '> '> '> '> '> '> '> onclick=btn_search_Click /> using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; //SqlConnection conn = new SqlConnection(connStr); SqlDataAdapter ad = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand(); DataTable dataTable; SqlDataAdapter sqlda; DataSet ds; string str; protected void Page_Load(object sender EventArgs e) { Session[sortBy] = null; if (!IsPostBack) { FillVendorGrid(); } } private void FillVendorGrid() { SqlConnection conn = new SqlConnection(connStr); dataTable = new DataTable(); cmd.Connection = conn; cmd.CommandText = SELECT * FROM Vendor; ad = new SqlDataAdapter(cmd); ad.Fill(dataTable); ResultGridView.DataSource = dataTable; ResultGridView.DataBind(); } protected void ResultGridView_RowEditing(object sender GridViewEditEventArgs e) { ResultGridView.EditIndex = e.NewEditIndex; FillVendorGrid(); } protected void ResultGridView_PageIndexChanging(object sender GridViewPageEventArgs e) { ResultGridView.PageIndex = e.NewPageIndex; FillVendorGrid(); } protected void ResultGridView_RowDeleting(object sender GridViewDeleteEventArgs e) { SqlConnection conn = new SqlConnection(connStr); cmd.Connection = conn; cmd.CommandText = DELETE FROM Vendor WHERE VendorId=' + ResultGridView.DataKeys[e.RowIndex].Values[0].ToString() + '; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); FillVendorGrid(); } protected void ResultGridView_RowUpdating(object sender GridViewUpdateEventArgs e) { TextBox txtFName = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl(txtFName); TextBox txtLName = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl(txtLName); TextBox txtCity = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl(txtCity); TextBox txtState = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl(txtState); TextBox txtCountry = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl(txtCountry); TextBox txtDescription = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl(txtDescription); SqlConnection conn = new SqlConnection(connStr); cmd.Connection = conn; cmd.CommandText = UPDATE Vendor SET VendorFName =' + txtFName.Text + 'VendorLName =' + txtLName.Text + 'VendorCity =' + txtCity.Text + 'VendorState =' + txtState.Text + 'VendorCountry =' + txtCountry.Text + 'VendorDescription =' + txtDescription.Text + ' WHERE VendorId=' + ResultGridView.DataKeys[e.RowIndex].Values[0].ToString() + '; conn.Open(); cmd.ExecuteNonQuery(); ResultGridView.EditIndex = -1; FillVendorGrid(); conn.Close(); } protected void ResultGridView_RowCancelingEdit(object sender GridViewCancelEditEventArgs e) { ResultGridView.EditIndex = -1; FillVendorGrid(); } protected void ResultGridView_RowCommand(object sender GridViewCommandEventArgs e) { if (e.CommandName.Equals(AddNew)) { TextBox txtFName = (TextBox)ResultGridView.FooterRow.FindControl(txtFName1); TextBox txtLName = (TextBox)ResultGridView.FooterRow.FindControl(txtLName1); TextBox txtCity = (TextBox)ResultGridView.FooterRow.FindControl(txtCity1); TextBox txtState = (TextBox)ResultGridView.FooterRow.FindControl(txtState1); TextBox txtCountry = (TextBox)ResultGridView.FooterRow.FindControl(txtCountry1); TextBox txtDescription = (TextBox)ResultGridView.FooterRow.FindControl(txtDescription1); SqlConnection conn = new SqlConnection(connStr); cmd.Connection = conn; cmd.CommandText = INSERT INTO Vendor(VendorFName VendorLNameVendorCityVendorStateVendorCountryVendorDescription) Values(' + txtFName.Text + ' ' + txtLName.Text + ' ' + txtCity.Text + ' ' + txtState.Text + ' ' + txtCountry.Text + '  ' + txtDescription.Text + '); conn.Open(); cmd.ExecuteNonQuery(); FillVendorGrid(); conn.Close(); } } protected void btn_search_Click(object sender EventArgs e) { SqlConnection conn = new SqlConnection(connStr); conn.Open(); str = select * from Vendor where VendorFName like ' + TextBox1.Text + %'; cmd = new SqlCommand(str conn); sqlda = new SqlDataAdapter(cmd); ds = new DataSet(); sqlda.Fill(ds Vendor); conn.Close(); ResultGridView.DataSource = ds; ResultGridView.DataMember = Vendor; ResultGridView.DataBind(); } protected void ResultGridView_Sorting(object sender GridViewSortEventArgs e) { Session[sortBy] = e.SortExpression; FillVendorGrid(); } } Thanks If this post helps you mark it as answer

Sukesh Marla · Answer

Use EditTemplate in GridView TemplateField Check this link http://www.codeproject.com/Articles/18136/Edit-Individual-GridView-Cells-in-ASP-NET C heck this is correct answer if it helped.