GridView custom Edit button... : The Official Microsoft ASP.NET Forums

Reply

dotnetruler

Contributor

4230 Points

GridView custom Edit button...

Jan 06, 2009 07:29 PM|LINK

Hi I am trying to put an edit button in the grid view. My code looks like this View
Delete I was trying to do include another button called Edit .. which should enable user to edit the code. i am not able to use the asp.net inbuilt Edit feature in that. I even tried to use another link button and given the command name as edit. If i give like this i am able to trigger the GridView_Rowediting event. But not able to get the buttons Update and Cancel when i click on the edit. Does any one have any clue ? Help me ......... Thanks in Advance

Better Post your code before asking a question. So that person helping u will understand u r problem Clearly

Yahoo IM : dotnetruler

I am trying to keep Frequently Asked Questions in my blog

Reply

ecbruck

All-Star

98783 Points

9691 Posts

Moderator

Re: GridView custom Edit button...

Jan 06, 2009 07:45 PM|LINK

Here's a full CRUD example for you that should help you out:

ASPX

<%@ page autoeventwireup="true" codefile="CRUDWithADO.aspx.cs" inherits="GridView_CRUDWithADO"
	language="C#" masterpagefile="~/MasterPages/Default.master" title="GridView: CRUD With ADO" %>


<asp:content id="Content1" runat="Server" contentplaceholderid="ContentPlaceHolder1">
	<asp:label id="lblMessage" runat="server" enableviewstate="false" />
	<asp:gridview id="gvShippers" runat="server" allowpaging="True" allowsorting="True"
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;">
		<columns>
			<asp:templatefield>
				<itemtemplate>
					<asp:linkbutton id="btnSelect" runat="server" commandname="Select" text="Select" />
					<asp:linkbutton id="btnEdit" runat="server" commandname="Edit" text="Edit" />
					<asp:linkbutton id="btnDelete" runat="server" commandname="Delete" text="Delete" />
				</itemtemplate>
				<edititemtemplate>
					<asp:linkbutton id="btnUpdate" runat="server" commandname="Update" text="Update" />
					<asp:linkbutton id="btnCancel" runat="server" commandname="Cancel" text="Cancel" />
				</edititemtemplate>
				<footertemplate>
					<asp:linkbutton id="btnInsert" runat="server" commandname="Insert" text="Insert" />
				</footertemplate>
			</asp:templatefield>
			<asp:boundfield datafield="ShipperID" headertext="ShipperID" insertvisible="false"
readonly="true" sortexpression="ShipperID" />
			<asp:templatefield headertext="CompanyName" sortexpression="CompanyName">
				<itemtemplate>
					<%# Eval("CompanyName") %>
				</itemtemplate>
				<edititemtemplate>
					<asp:textbox id="txtCompanyName" runat="server" text='<%# Bind("CompanyName") %>' />
				</edititemtemplate>
				<footertemplate>
					<asp:textbox id="txtCompanyName" runat="server" />
				</footertemplate>
			</asp:templatefield>
			<asp:templatefield headertext="Phone" sortexpression="Phone">
				<itemtemplate>
					<%# Eval("Phone") %>
				</itemtemplate>
				<edititemtemplate>
					<asp:textbox id="txtPhone" runat="server" text='<%# Bind("Phone") %>' />
				</edititemtemplate>
				<footertemplate>
					<asp:textbox id="txtPhone" runat="server" />
				</footertemplate>
			</asp:templatefield>
		</columns>
	</asp:gridview>
</asp:content>

CODE-BEHIND

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_CRUDWithADO : 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<string, object> 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<string, object> values = new Dictionary<string, object>();

        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 {}
			}
		}
	}
}

Thanks, Ed

Microsoft MVP - ASP.NET

Marked as answer by dotnetruler on Jan 06, 2009 07:52 PM

Reply

dotnetruler

Contributor

4230 Points

753 Posts

Re: GridView custom Edit button...

Jan 06, 2009 07:56 PM|LINK

Hey Thank you Verymuch..... Looks like got it what i am looking for..

Better Post your code before asking a question. So that person helping u will understand u r problem Clearly

Yahoo IM : dotnetruler

I am trying to keep Frequently Asked Questions in my blog

Reply

sanketpathre

Member

317 Points

88 Posts

Re: GridView custom Edit button...

Dec 17, 2009 06:06 AM|LINK

Thanks for your answer.

I have found one problem with above code

While inserting i have added some required field validator in footer template.

I found out that footer control id are preceded with "-1" at clientSide which give javascript error on page. Also, because of this, no other script are able to fire on page. I am using VS 2010.
Any solution to avoid id to be preceded with -1.
Note: I am working on asp.net 4.0 Framework. This error is occured in project in same framework version. When i tested code in VS2008 web app project, it work properly with out any javascript error.

I have started new post on this problem :http://forums.asp.net/p/1505081/3570514.aspx#3570514

Edited by sanketpathre on Dec 17, 2009 12:46 PM

Reply

Chit Min Mau...

Member

79 Points

77 Posts

Re: GridView custom Edit button...

Apr 27, 2010 03:50 AM|LINK

Hi ecbruck,

Thanks for your post... And I just want to extend to combine column... How should I do that...

Now my grid is like this...

Company Name	Issued Date	Quotation1	Quotation2	Validity1	Validity2
ABC	27/04/2010	Q-01/ABC/2010	Q-02/ABC/2010	27/04/2010	27/05/2010

I want to be like this...

Company Name	Issued Date	Quotation1	Validity1
		Quotation2	Validity2
ABC	27/04/2010	Q-01/ABC/2010	27/04/2010
		Q-02/ABC/2010	27/05/2010

And I referenced based on your code...

but I used the data from database....

If you have any idea, pls give me advice... thx..

Chit Min Maung
MCTS/ MCP
Analyst Programmer
http://www.cmmaung.me/

If this post helped you, please mark as Answer.

Reply

adeelgr8

Member

2 Points

1 Post

Re: GridView custom Edit button...

Nov 09, 2012 08:45 AM|LINK

Man this is the best.After spending some time with java ;I just forgotten the crud functionality in GridView.Furthermore the color combinations you used are attracted enough to put more concentration right from the first line till the last line.Thanks and regards

GridView custom Edit button... RSS

5 replies

dotnetruler

GridView custom Edit button...

ecbruck

Re: GridView custom Edit button...

dotnetruler

Re: GridView custom Edit button...

sanketpathre

Re: GridView custom Edit button...

Chit Min Mau...

Re: GridView custom Edit button...

adeelgr8

Re: GridView custom Edit button...

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Microsoft