Make ASP.Net GridView row Read only for specific time after updating value in C#

alhamd

SOLVED CLOSED ACTIVE ANSWERED
User: alhamd
Posted: on Jul 21, 2023 06:18 AM
Forum: Data Controls
Answer: 2
Views: 2297
Sample Code: Download

I have a GridView data like that.

When any row is updated once, then this specific row should be read only for 1 hour and Edit button also must be invisible for 1 hour.

How to get solution plz

HTML

<div class="table-responsive">
    <asp:GridView ID="GridView1" runat="server" AllowPaging="false" CssClass="table table-striped table-bordered table-hover"
        Font-Bold="true" Font-Names="Jameel Noori Nastaleeq" Font-Size="14" AutoGenerateColumns="false"
        RowStyle-Wrap="true" HeaderStyle-Wrap="false" HeaderStyle-BackColor="#3AC0F2"
        HeaderStyle-ForeColor="White" RowStyle-BackColor="#A1DCF2" AlternatingRowStyle-BackColor="White"
        RowStyle-ForeColor="#3A3A3A" OnRowDataBound="OnRowDataBound" OnRowCancelingEdit="GridView1_RowCancelingEdit"
        OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating">
        <Columns>
            <asp:CommandField ShowEditButton="True" />
            <asp:TemplateField HeaderText="Choose Ans">
                <EditItemTemplate>
                    <asp:DropDownList ID="ddlRemarks" class="form-control" runat="server">
                        <asp:ListItem>A</asp:ListItem>
                        <asp:ListItem>B</asp:ListItem>
                        <asp:ListItem>C</asp:ListItem>
                        <asp:ListItem>D</asp:ListItem>
                    </asp:DropDownList>
                </EditItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="آپشن ڈی">
                <ItemTemplate>
                    <asp:Label ID="lbl_QuestionD" runat="server" Text='<%# Bind("OpDU") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="آپشن سی">
                <ItemTemplate>
                    <asp:Label ID="lbl_QuestionC" runat="server" Text='<%# Bind("OpCU") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="آپشن بی">
                <ItemTemplate>
                    <asp:Label ID="lbl_QuestionB" runat="server" Text='<%# Bind("OpBU") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="آپشن اے">
                <ItemTemplate>
                    <asp:Label ID="lbl_QuestionA" runat="server" Text='<%# Bind("OpAU") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>

            <asp:TemplateField HeaderText="سوال">
                <ItemTemplate>
                    <asp:Label ID="lbl_Question" runat="server" Text='<%# Bind("QuestionU") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Code">
                <ItemTemplate>
                    <asp:Label ID="lbl_Code" runat="server" Text='<%# Bind("QID") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
    </asp:GridView>
</div>

Code

protected void ddlType_SelectedIndexChanged(object sender, EventArgs e)
{
    BindGridQ();
}

private void BindGridQ()
{
    con = new SqlDbConnect();
    con.SqlQuery("select QID, QuestionU, OpAU, OpBU, OpCU, OpDU, OptionA from tblQuestionCreate where ClassID=@CID and SubjectID=@SID and QTypeID= @TID order by QID asc;");
    con.Cmd.Parameters.Add(new SqlParameter("@CID", ddlClass.SelectedValue.ToString()));
    con.Cmd.Parameters.Add(new SqlParameter("@SID", ddlSubjects.SelectedValue.ToString()));
    con.Cmd.Parameters.Add(new SqlParameter("@TID", ddlType.SelectedValue.ToString()));
    adapt.SelectCommand = con.Cmd;
    adapt.Fill(sTable);
    if (sTable.Rows.Count > 0)
    {
        GridView1.Visible = true;
        GridView1.DataSource = sTable;
        GridView1.DataBind();
        // GridView1.Rows[i].BackColor = System.Drawing.Color.Yellow;

    }
    else
    {
        GridView1.Visible = false;
        Response.Write("No Record Found");
        return;
    }
    con.conClose();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
    GridView1.EditIndex = -1;
    this.BindGrid();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
    GridView1.EditIndex = e.NewEditIndex;
    this.BindGrid();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
    Label Code = (Label)GridView1.Rows[e.RowIndex].FindControl("lbl_Code");
    DropDownList ddlRemarks = GridView1.Rows[e.RowIndex].FindControl("ddlRemarks") as DropDownList;

    con = new SqlDbConnect();
    con.SqlQuery("Update tblQuestionCreate set OptionA=@Status where QID=@No");
    con.Cmd.Parameters.Add(new SqlParameter("@No", Code.Text));
    con.Cmd.Parameters.Add(new SqlParameter("@Status", ddlRemarks.SelectedItem.Text));
    con.NonQueryEx();
    con.conClose();
    GridView1.EditIndex = -1;
    this.BindGrid();
    //ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Answer Updated');", true);
}

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 2

Reply
ANSWER
User: Mudassar
Replied: on Jul 23, 2023 06:28 AM
Modified: on Jul 23, 2023 06:31 AM
Report

Hi,

Try this

Database

I have made use of the following table Customers with the schema as follows.

Make Column (Cell) non editable (ReadOnly) in ASP.Net GridView with AutoGenerateColumns true

I have already inserted few records in the table.

Make Column (Cell) non editable (ReadOnly) in ASP.Net GridView with AutoGenerateColumns true

Note: You can download the database table SQL by clicking the download link below.

Download SQL file

HTML

<asp:GridView ID="GridView1" runat="server" DataKeyNames="CustomerId" OnRowDataBound ="OnRowDataBound" OnRowEditing="OnRowEditing"
 OnRowCancelingEdit="OnRowCancelingEdit" OnRowUpdating="OnRowUpdating" AutoGenerateEditButton="true">
</asp:GridView>

Namespaces

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

Code

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("SELECT CustomerId, Name, Country, ModifiedDate FROM Customers_EditTime"))
        {
            using (SqlDataAdapter sda = new SqlDataAdapter())
            {
                cmd.Connection = con;
                sda.SelectCommand = cmd;
                using (DataTable dt = new DataTable())
                {
                    sda.Fill(dt);
                    GridView1.DataSource = dt;
                    GridView1.DataBind();
                }
            }
        }
    }
}
protected void OnRowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        DataRowView dr = (DataRowView)e.Row.DataItem;
        DateTime modifiedDate = dr["ModifiedDate"] != DBNull.Value ? Convert.ToDateTime(dr[3]) : DateTime.MinValue;
        LinkButton lnkEdit = e.Row.Cells[0].Controls[0] as LinkButton;
        lnkEdit.Enabled = (DateTime.Now - modifiedDate).Hours > 1;
    }
}

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

protected void OnRowCancelingEdit(object sender, EventArgs e)
{
    GridView1.EditIndex = -1;
    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]);
    string name = (row.Cells[2].Controls[0] as TextBox).Text;
    string country = (row.Cells[3].Controls[0] as TextBox).Text;
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("UPDATE Customers_EditTime SET Name = @Name, Country = @Country, ModifiedDate = GETDATE() WHERE CustomerId = @CustomerId"))
        {
            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();

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Make ASP.Net GridView row Read only for specific time after updating value in C#

Company

Explore

Follow us

Contact Us