Update ASP.Net GridView cell value based on TextBox using C#

smile

SOLVED CLOSED ACTIVE ANSWERED
User: smile
Posted: on May 06, 2018 12:46 PM
Forum: Data Controls
Answer: 1
Views: 11246

Change gridview value from Absent to Present if gridview value match outside textbox value

I WANT TO CHANGE THE ATTENDANCE STATUS PRESENT INSIDE GRIDVIEW WHEN THE STUDENT ADMISSION NO IS ENETERED IN THE TEXTBOX OUTSIDE THE GRIDVIEW. HOW TO DO IT

        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Class="table table-striped table-bordered table-hover" OnRowDataBound = "OnRowDataBound">  
            <Columns>      
                <asp:TemplateField HeaderText="Admission No">  
                    <ItemTemplate>  
                        <asp:Label ID="lbl_AdNo" runat="server" Text='<%#Eval("AdmissionNo") %>'></asp:Label>  
                    </ItemTemplate>                    
                </asp:TemplateField> 
                <asp:TemplateField HeaderText="Roll No">  
                    <ItemTemplate>  
                        <asp:Label ID="lbl_RollNo" runat="server" Text='<%#Eval("RollNo") %>'></asp:Label>  
                    </ItemTemplate>                    
                </asp:TemplateField> 
                <asp:TemplateField HeaderText="Student Name">  
                    <ItemTemplate>  
                        <asp:Label ID="lbl_SName" runat="server" Text='<%#Eval("SName") %>'></asp:Label>  
                    </ItemTemplate>                    
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Father Phone">  
                    <ItemTemplate>  
                        <asp:Label ID="lbl_FPhone" runat="server" Text='<%#Eval("FPhone") %>'></asp:Label>  
                    </ItemTemplate>                    
                </asp:TemplateField>
                 <asp:TemplateField>
                        <HeaderTemplate>Status</HeaderTemplate>
                         <ItemTemplate>
                            <asp:Label ID="lbl_Status" runat="server" Text="Absent"></asp:Label>  
                         </ItemTemplate>
                    </asp:TemplateField>                
            </Columns>              
        </asp:GridView>

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.BindGrid();
            DateTime ADate = DateTime.Now;
            txtDate.Text = ADate.ToString("dd.MM.yyyy") + " " + ADate.DayOfWeek.ToString();
        }
    }
    protected void BindGrid()
    {
        GridView1.Visible = true;
        con = new SqlDbConnect();
        con.SqlQuery("select AdmissionNo,RollNo,SName,FPhone from tblStdReg where Active_Status='Active' order by RollNo;");
        adapt.SelectCommand = con.Cmd;
        adapt.Fill(sTable);
        if (sTable.Rows.Count > 0)
        {
            GridView1.Visible = true;
            GridView1.DataSource = sTable;
            GridView1.DataBind();
            lblTotal.Text = GridView1.Rows.Count.ToString();
        }
        else
        {
            GridView1.Visible = false;
            ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('No Record Found');", true);
            lblTotal.Text = "0";
            return;
        }
        con.conClose();
    }
    protected void btnAtten_Click(object sender, EventArgs e)
    {
        int i = 0;
        GridViewRow row = GridView1.Rows[i];

        con = new SqlDbConnect();
        con.SqlQuery("select AdmissionNo from tblStdReg where AdmissionNo=@AdNo");
        con.Cmd.Parameters.Add(new SqlParameter("@AdNo", this.txtRegNo.Text.Trim()));
        con.RdrEx();
        if (con.Rdr.Read())
        {
          string lblStatus = (row.FindControl("lbl_Status") as Label).Text;
          lblStatus = "Present";
          Response.Write("This"+txtRegNo.Text+"-"+lblStatus);
        }
        else 
        {
            Response.Write("Reg. No. not found Try again");
        }
    }

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

kalpesh

0 4

Reply
ANSWER
User: kalpesh
Replied: on May 07, 2018 02:10 AM
Modified: on May 09, 2018 01:40 AM
Report

You just need to check the value entered in textbox as Admission no present in Grid records? Then just the loop through the GridViewRow records from GridView1.Rows and match the txtRegNo with each row lbl_AdNo value.

HTML

<div>
    Reg No:<asp:TextBox ID="txtRegNo" runat="server"></asp:TextBox>
    <asp:Button ID="btnAtten" runat="server" OnClick="btnAtten_Click" Text="Search" />
    <br />
    <br />
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Class="table table-striped table-bordered table-hover"
        OnRowDataBound="OnRowDataBound">
        <Columns>
            <asp:TemplateField HeaderText="Admission No">
                <ItemTemplate>
                    <asp:Label ID="lbl_AdNo" runat="server" Text='<%#Eval("AdmissionNo") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Roll No">
                <ItemTemplate>
                    <asp:Label ID="lbl_RollNo" runat="server" Text='<%#Eval("RollNo") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Student Name">
                <ItemTemplate>
                    <asp:Label ID="lbl_SName" runat="server" Text='<%#Eval("SName") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Father Phone">
                <ItemTemplate>
                    <asp:Label ID="lbl_FPhone" runat="server" Text='<%#Eval("FPhone") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField>
                <HeaderTemplate>
                    Status</HeaderTemplate>
                <ItemTemplate>
                    <asp:Label ID="lbl_Status" runat="server" Text="Absent"></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
    </asp:GridView>
</div>

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[4] { new DataColumn("AdmissionNo",typeof(string))
                                                ,new DataColumn("RollNo",typeof(string))      
                                                ,new DataColumn("SName",typeof(string))
                                                ,new DataColumn("FPhone",typeof(string))
        });
        dt.Rows.Add("R-000001", "0", "FATIMA ZAHARA", "1000000000");
        dt.Rows.Add("R-000002", "0", "KINZA WAJID", "2000000000");
        dt.Rows.Add("R-000003", "0", "MUHAMMAD FAIZAN", "3000000000");
        dt.Rows.Add("R-000004", "0", "RIYAN HAIDAR", "4000000000");
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
}
protected void btnAtten_Click(object sender, EventArgs e)
{
    bool isRecordExists = false;

    foreach (GridViewRow row in GridView1.Rows)
    {
        string lbl_AdNo = (row.FindControl("lbl_AdNo") as Label).Text;
        if (!string.IsNullOrEmpty(txtRegNo.Text) && this.txtRegNo.Text.Trim() == lbl_AdNo)
        {
            txtRegNo.Text = this.txtRegNo.Text.Trim();
            (row.FindControl("lbl_Status") as Label).Text = "Present";
            isRecordExists = true;
        }
    }

    if (!isRecordExists)
    {
        // Your alrert box message or your old code of Response.Write
        //Response.Write("Reg. No. not found Try again");
    }
}

Screenshot

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

Update ASP.Net GridView cell value based on TextBox using C#

Company

Explore

Follow us

Contact Us