Range Validation in ASP.Net GridView row Editing using C# and VB.Net

I will get back soon.

Thx pandeyism

I'm waiting for your response

Hi dorsa,

Refer below sample.

HTML

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script type="text/javascript">
    $(function () {
        $('[id*=GridView1] tr td').on('click', function () {
            $('[id*=GridView1] tr td').each(function () {
                if ($(this).index() <= 1) {
                    $(this).find('span').show();
                    $(this).find('select').hide();
                    $(this).find('input[type=text]').hide();
                    $(this).find('span').html($(this).find('input[type=text]').val());
                }
            });
            var val = $(this).find('span').html();
            $(this).find('span').hide();
            $(this).find('select').show();
            $(this).find('input[type=text]').val(val);
            $(this).find('input[type=text]').show();
            $(this).find('input[type=text]').focus();
        });
    });
</script>
<div>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowEditing="GridView1_RowEditing"
        OnRowUpdating="GridView1_OnRowUpdating" OnRowCancelingEdit="GridView1_OnRowCancelingEdit">
        <Columns>
            <asp:TemplateField HeaderText="Mark" SortExpression="Mark">
                <ItemTemplate>
                    <asp:Label ID="lbl_Text1" runat="server" Text='<%# Bind("Mark") %>'></asp:Label>
                    <asp:TextBox ID="txt_Text1" runat="server" CssClass="hideControl" Text='<%# Bind("Mark") %>'></asp:TextBox>
                </ItemTemplate>
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox1" runat="server" CssClass="hideControl" Text='<%# Bind("Mark") %>'></asp:TextBox>
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="TextBox1"
                        ErrorMessage="*" ForeColor="Red"></asp:RequiredFieldValidator>
                    <asp:RangeValidator runat="server" ID="rvRange" MaximumValue="20" MinimumValue="0"
                        Type="Integer" ControlToValidate="TextBox1" ErrorMessage="*" ForeColor="Red"></asp:RangeValidator>
                </EditItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="AttendanceStatus " SortExpression="AttendanceStatus">
                <ItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%#Bind("AttendanceStatus") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:CommandField ShowEditButton="true" />
        </Columns>
    </asp:GridView>
</div>

Namespaces

C#

using System.Configuration;
using System.Data.SqlClient;
using System.Data;

VB.Net

Imports System.Data.SqlClient
Imports System.Data

Code

C#

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

private void BindGrid()
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT * FROM UpdateTable1", con))
        {
            using (SqlDataAdapter da = new SqlDataAdapter(cmd))
            {
                DataTable dt = new DataTable();
                da.Fill(dt);
                GridView1.DataSource = dt;
                GridView1.DataBind();
            }
        }
    }
}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
    GridView1.EditIndex = e.NewEditIndex;
    BindGrid();
}

protected void GridView1_OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
    GridViewRow row = GridView1.Rows[e.RowIndex];
    int mark = Convert.ToInt16((row.FindControl("TextBox1") as TextBox).Text);
    string id = (row.FindControl("Label1") as Label).Text;
    string query = "UPDATE UpdateTable1 SET Mark = @mark WHERE id = @Id";
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand(query, con))
        {
            cmd.Parameters.AddWithValue("@mark", mark);
            cmd.Parameters.AddWithValue("@Id", id);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }
    }
    BindGrid();
}

protected void GridView1_OnRowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
    GridView1.EditIndex = -1;
    BindGrid();
}

VB.Net

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

Private Sub BindGrid()
    Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Using con As SqlConnection = New SqlConnection(constr)
        Using cmd As SqlCommand = New SqlCommand("SELECT * FROM UpdateTable1", con)
            Using da As SqlDataAdapter = New SqlDataAdapter(cmd)
                Dim dt As DataTable = New DataTable()
                da.Fill(dt)
                GridView1.DataSource = dt
                GridView1.DataBind()
            End Using
        End Using
    End Using
End Sub

Protected Sub GridView1_RowEditing(ByVal sender As Object, ByVal e As GridViewEditEventArgs)
    GridView1.EditIndex = e.NewEditIndex
    BindGrid()
End Sub

Protected Sub GridView1_OnRowUpdating(ByVal sender As Object, ByVal e As GridViewUpdateEventArgs)
    Dim row As GridViewRow = GridView1.Rows(e.RowIndex)
    Dim mark As Integer = Convert.ToInt16((TryCast(row.FindControl("TextBox1"), TextBox)).Text)
    Dim id As String = (TryCast(row.FindControl("Label1"), Label)).Text
    Dim query As String = "UPDATE UpdateTable1 SET Mark = @mark WHERE id = @Id"
    Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Using con As SqlConnection = New SqlConnection(constr)
        Using cmd As SqlCommand = New SqlCommand(query, con)
            cmd.Parameters.AddWithValue("@mark", mark)
            cmd.Parameters.AddWithValue("@Id", id)
            con.Open()
            cmd.ExecuteNonQuery()
            con.Close()
        End Using
    End Using
    BindGrid()
End Sub

Protected Sub GridView1_OnRowCancelingEdit(ByVal sender As Object, ByVal e As GridViewCancelEditEventArgs)
    GridView1.EditIndex = -1
    BindGrid()
End Sub

Screenshot