How to use Ajax Text Editor in GridView Row Editing using C# and VB.Net in ASP.Net

Hi fareed.fd7,

I have created sample code which full-fill your requirement. So please refer the below code and modify as per your requirement.

HTML

<form id="form1" runat="server">
<div>
    <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
    </asp:ToolkitScriptManager>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" DataKeyNames="CustomerId"
        OnRowDataBound="OnRowDataBound" OnRowEditing="OnRowEditing" OnRowCancelingEdit="OnRowCancelingEdit"
        OnRowUpdating="OnRowUpdating" OnRowDeleting="OnRowDeleting" EmptyDataText="No records has been added.">
        <Columns>
            <asp:TemplateField HeaderText="Name" ItemStyle-Width="150">
                <ItemTemplate>
                    <asp:Label ID="lblName" runat="server" Text='<%# Eval("Name") %>'></asp:Label>
                </ItemTemplate>
                <EditItemTemplate>
                    <HTMLEditor:Editor runat="server" ID="txtName" ClientIDMode="AutoID" Content='<%# Eval("Name") %>'
                        Height="30px" AutoFocus="true" Width="150px" />
                </EditItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Country" ItemStyle-Width="150">
                <ItemTemplate>
                    <asp:Label ID="lblCountry" runat="server" Text='<%# Eval("Country") %>'></asp:Label>
                </ItemTemplate>
                <EditItemTemplate>
                    <HTMLEditor:Editor runat="server" ID="txtCountry" ClientIDMode="AutoID" Content='<%# Eval("Country") %>'
                        Height="30px" AutoFocus="true" Width="150px" />
                </EditItemTemplate>
            </asp:TemplateField>
            <asp:CommandField ButtonType="Link" ShowEditButton="true" ShowDeleteButton="true"
                ItemStyle-Width="150" />
        </Columns>
    </asp:GridView>
</div>
</form>

Register Assembly

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit.HTMLEditor"
    TagPrefix="HTMLEditor" %>

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.BindGrid();
    }
}

private void BindGrid()
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("Customers_CRUD"))
        {
            cmd.Parameters.AddWithValue("@Action", "SELECT");
            using (SqlDataAdapter sda = new SqlDataAdapter())
            {
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Connection = con;
                sda.SelectCommand = cmd;
                using (DataTable dt = new DataTable())
                {
                    sda.Fill(dt);
                    GridView1.DataSource = dt;
                    GridView1.DataBind();
                }
            }
        }
    }
}

protected void OnRowEditing(object sender, GridViewEditEventArgs e)
{
    GridView1.EditIndex = e.NewEditIndex;
    this.BindGrid();
}
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
    GridViewRow row = GridView1.Rows[e.RowIndex];
    int customerId = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]);
    AjaxControlToolkit.HTMLEditor.Editor rName = (AjaxControlToolkit.HTMLEditor.Editor)row.FindControl("txtName") as AjaxControlToolkit.HTMLEditor.Editor;
    string name = rName.Content;
    AjaxControlToolkit.HTMLEditor.Editor rcountry = (AjaxControlToolkit.HTMLEditor.Editor)row.FindControl("txtCountry") as AjaxControlToolkit.HTMLEditor.Editor;
    string country = rcountry.Content;
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("Customers_CRUD"))
        {
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@Action", "UPDATE");
            cmd.Parameters.AddWithValue("@CustomerId", customerId);
            cmd.Parameters.AddWithValue("@Name", name);
            cmd.Parameters.AddWithValue("@Country", country);
            cmd.Connection = con;
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }
    }

    GridView1.EditIndex = -1;
    this.BindGrid();
}

protected void OnRowCancelingEdit(object sender, EventArgs e)
{
    GridView1.EditIndex = -1;
    this.BindGrid();
}

protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e)
{
    int customerId = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]);
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("Customers_CRUD"))
        {
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@Action", "DELETE");
            cmd.Parameters.AddWithValue("@CustomerId", customerId);
            cmd.Connection = con;
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }
    }
    this.BindGrid();
}

protected void OnRowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow && e.Row.RowIndex != GridView1.EditIndex)
    {
        (e.Row.Cells[2].Controls[2] as LinkButton).Attributes["onclick"] = "return confirm('Do you want to delete this row?');";
    }
}

Vb.net

Protected Sub Page_Load(sender As Object, e As EventArgs)
	If Not Me.IsPostBack Then
		Me.BindGrid()
	End If
End Sub

Private Sub BindGrid()
	Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
	Using con As New SqlConnection(constr)
		Using cmd As New SqlCommand("Customers_CRUD")
			cmd.Parameters.AddWithValue("@Action", "SELECT")
			Using sda As New SqlDataAdapter()
				cmd.CommandType = CommandType.StoredProcedure
				cmd.Connection = con
				sda.SelectCommand = cmd
				Using dt As New DataTable()
					sda.Fill(dt)
					GridView1.DataSource = dt
					GridView1.DataBind()
				End Using
			End Using
		End Using
	End Using
End Sub

Protected Sub OnRowEditing(sender As Object, e As GridViewEditEventArgs)
	GridView1.EditIndex = e.NewEditIndex
	Me.BindGrid()
End Sub
Protected Sub OnRowUpdating(sender As Object, e As GridViewUpdateEventArgs)
	Dim row As GridViewRow = GridView1.Rows(e.RowIndex)
	Dim customerId As Integer = Convert.ToInt32(GridView1.DataKeys(e.RowIndex).Values(0))
	Dim rName As AjaxControlToolkit.HTMLEditor.Editor = TryCast(DirectCast(row.FindControl("txtName"), AjaxControlToolkit.HTMLEditor.Editor), AjaxControlToolkit.HTMLEditor.Editor)
	Dim name As String = rName.Content
	Dim rcountry As AjaxControlToolkit.HTMLEditor.Editor = TryCast(DirectCast(row.FindControl("txtCountry"), AjaxControlToolkit.HTMLEditor.Editor), AjaxControlToolkit.HTMLEditor.Editor)
	Dim country As String = rcountry.Content
	Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
	Using con As New SqlConnection(constr)
		Using cmd As New SqlCommand("Customers_CRUD")
			cmd.CommandType = CommandType.StoredProcedure
			cmd.Parameters.AddWithValue("@Action", "UPDATE")
			cmd.Parameters.AddWithValue("@CustomerId", customerId)
			cmd.Parameters.AddWithValue("@Name", name)
			cmd.Parameters.AddWithValue("@Country", country)
			cmd.Connection = con
			con.Open()
			cmd.ExecuteNonQuery()
			con.Close()
		End Using
	End Using

	GridView1.EditIndex = -1
	Me.BindGrid()
End Sub

Protected Sub OnRowCancelingEdit(sender As Object, e As EventArgs)
	GridView1.EditIndex = -1
	Me.BindGrid()
End Sub

Protected Sub OnRowDeleting(sender As Object, e As GridViewDeleteEventArgs)
	Dim customerId As Integer = Convert.ToInt32(GridView1.DataKeys(e.RowIndex).Values(0))
	Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
	Using con As New SqlConnection(constr)
		Using cmd As New SqlCommand("Customers_CRUD")
			cmd.CommandType = CommandType.StoredProcedure
			cmd.Parameters.AddWithValue("@Action", "DELETE")
			cmd.Parameters.AddWithValue("@CustomerId", customerId)
			cmd.Connection = con
			con.Open()
			cmd.ExecuteNonQuery()
			con.Close()
		End Using
	End Using
	Me.BindGrid()
End Sub

Protected Sub OnRowDataBound(sender As Object, e As GridViewRowEventArgs)
	If e.Row.RowType = DataControlRowType.DataRow AndAlso e.Row.RowIndex <> GridView1.EditIndex Then
		TryCast(e.Row.Cells(2).Controls(2), LinkButton).Attributes("onclick") = "return confirm('Do you want to delete this row?');"
	End If
End Sub

Screenshot