Disable editing ASP.Net GridView Row based on condition using C# and VB.Net

Hi dorsa,

Refer below sample.

HTML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowEditing="GridView1_RowEditing"
    OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit">
    <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" Text='<%# Bind("Mark") %>'></asp:TextBox>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="ExamAttendanceTypeId " SortExpression="ExamAttendanceTypeId">
            <EditItemTemplate>
                <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Id") %>' ReadOnly="true"></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
                <asp:Label ID="Label1" runat="server" Text='<%# ShowAttendanceStatus(Eval("Id")) %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:CommandField ButtonType="Link" ShowEditButton="true" />
    </Columns>
</asp:GridView>

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 string ShowAttendanceStatus(object i)
{
    if ((int)i == 1)
    {
        return "Present";
    }
    else if ((int)i == 2)
    {
        return "UnAcceptable Absent";
    }
    else
    {
        return " Acceptable absent ";
    }
}

public int ShowMarkResult(double MResult)
{
    if (MResult >= 0 && MResult < 10)
    {
        return 2;
    }
    else if (MResult >= 10 && MResult <= 20)
    {
        return 1;
    }
    return 0;
}

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

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
    GridViewRow row = GridView1.Rows[e.RowIndex];
    int mark = Convert.ToInt16((row.FindControl("txt_Text1") as TextBox).Text);
    string id = (row.FindControl("TextBox1") as TextBox).Text;
    if (Convert.ToInt16(id) != 2 && Convert.ToInt16(id) != 3)
    {
        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();
            }
        }
    }
    else
    {
        ScriptManager.RegisterStartupScript(this, this.GetType(), "sd", "alert('You can not update data !');", true);
    }
    GridView1.EditIndex = -1;
    this.BindGrid();
}

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
    GridView1.EditIndex = -1;
    this.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 Function ShowAttendanceStatus(ByVal i As Object) As String
    If CInt(i) = 1 Then
        Return "Present"
    ElseIf CInt(i) = 2 Then
        Return "UnAcceptable Absent"
    Else
        Return " Acceptable absent "
    End If
End Function

Public Function ShowMarkResult(ByVal MResult As Double) As Integer
    If MResult >= 0 AndAlso MResult < 10 Then
        Return 2
    ElseIf MResult >= 10 AndAlso MResult <= 20 Then
        Return 1
    End If

    Return 0
End Function

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

Protected Sub GridView1_RowUpdating(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("txt_Text1"), TextBox)).Text)
    Dim id As String = (TryCast(row.FindControl("TextBox1"), TextBox)).Text
    If Convert.ToInt16(id) <> 2 AndAlso Convert.ToInt16(id) <> 3 Then
        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
    Else
        ScriptManager.RegisterStartupScript(Me, Me.GetType(), "sd", "alert('You can not update data !');", True)
    End If

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

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

Screenshot