Hide row in GridView on LinkButton click in ASP.Net

sindiyen

SOLVED CLOSED ACTIVE ANSWERED
User: sindiyen
Posted: on Jun 19, 2018 12:05 AM
Forum: Data Controls
Answer: 1
Views: 3089
Sample Code: Download

Hello sir,

I am using multilevel login, one is user and another is supervisor,Superindent for the bill claim matters.

I had used the store procedure to submit the form and view the details using gridview all working fine.

The question is if the supervisor found the incomplete document produceed, he has to sendback the form to the user with remarks. this is my code.

<%@ Page Title="" Language="C#" MasterPageFile="~/Site1.Master" AutoEventWireup="true"
    CodeFile="FilterStatus.aspx.cs" Inherits="FilterStatus" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
    <link href="CSS/BootStrap.css" rel="stylesheet" />
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <div class="container">
        <div class="table">
            <asp:RadioButtonList ID="rblCountries" runat="server" AutoPostBack="true" OnSelectedIndexChanged="Country_Selected"
                RepeatDirection="Horizontal">
                <asp:ListItem Text="All" Value="" Selected="True"></asp:ListItem>
                <asp:ListItem Text="Pending" Value="Pending"></asp:ListItem>
                <asp:ListItem Text="Recommended" Value="Recommended"></asp:ListItem>
                <asp:ListItem Text="Not Recommended" Value="Not Recommended"></asp:ListItem>
                <asp:ListItem Text="More Doc Reqd" Value="More Doc Reqd"></asp:ListItem>
            </asp:RadioButtonList>
            <hr />
            <asp:GridView ID="GridView1" runat="server" CssClass="form-control" AutoGenerateColumns="false"
                OnRowCommand="GridView1_RowCommand" ShowHeaderWhenEmpty="true">
                <Columns>
                    <asp:BoundField DataField="EmpNo" HeaderText="Emp No" />
                    <asp:BoundField DataField="Name" HeaderText="Name" />
                    <asp:BoundField DataField="STATUS" HeaderText="STATUS" />
                    <asp:TemplateField>
                        <ItemTemplate>
                            <table class="auto-style2">
                                <tr>
                                    <td>
                                        <asp:Button ID="btnEdit" runat="server" CommandArgument="<%# ((GridViewRow) Container).RowIndex %>"
                                            CommandName="EditButton" CssClass="button" Text="Forward" Width="70" />
                                    </td>
                                    <td>
                                        <asp:Button ID="Button1" data-target="#sendback" runat="server" CommandArgument="<%# ((GridViewRow) Container).RowIndex %>"
                                            CommandName="SendbackButton" CssClass="btn btn-primary btn-sm" data-toggle="modal"
                                            Text="Send Back" />
                                    </td>
                                </tr>
                            </table>
                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>
                <EmptyDataTemplate>
                    <div align="center">
                        No records found.</div>
                </EmptyDataTemplate>
            </asp:GridView>
            <div class="modal" id="sendback" tabindex="-1">
                <div class="modal-dialog">
                    <div class="modal-content">
                        <div class="modal-header">
                            <button class="close" data-dismiss="modal">
                                &times;</button>
                            <h4 class="modal-header">
                                Send Back</h4>
                        </div>
                        <div class="modal-body">
                            <form>
                            <div class="form-group">
                                <label for="inputRecommendation">
                                    Recommendation</label>
                                <asp:DropDownList ID="ddlStatus" runat="server" DataSourceID="SqlDataSource1" AppendDataBoundItems="true">
                                    <asp:ListItem Text="Please select" Value="" />
                                </asp:DropDownList>
                                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:constr %>"
                                    SelectCommand="SELECT (STATUS) AS STATUS FROM mdetails"></asp:SqlDataSource>
                            </div>
                            <div class="form-group">
                                <label for="inputRemarks">
                                    Remarks</label>
                                <input class="form-group" placeholder="Remarks" type="text" id="Remarks" />
                            </div>
                            </form>
                        </div>
                        <div class="modal-footer">
                            <button class="btn btn-primary">
                                Send Back</button>
                            <button class="btn btn-primary" data-dismiss="modal">
                                Close</button>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</asp:Content>

public partial class FilterStatus : System.Web.UI.Page
{
    private void BindGrid()
    {
        string GSO1STATUS = rblCountries.SelectedItem.Value;
        string sql = "SELECT * FROM mdetails WHERE STATUS=@STATUS OR @STATUS = ''";
        string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand(sql))
            {
                cmd.Parameters.AddWithValue("@STATUS", STATUS);
                cmd.Connection = con;
                using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
                {
                    using (DataTable dt = new DataTable())
                    {
                        sda.Fill(dt);
                        GridView1.DataSource = dt;
                        GridView1.DataBind();
                    }
                }
            }
        }
    }

    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        int index = Convert.ToInt32(e.CommandArgument);
        GridViewRow row = GridView1.Rows[index];
        if (e.CommandName == "EditButton")
        {
            Response.Redirect("~/EditView.aspx?EmpNo=" + row.Cells[0].Text);
        }
      /*  if (e.CommandName == "ViewButton")
        {
            Response.Redirect("~/ViewRecord.aspx?EmpNo=" + row.Cells[0].Text);
        }*/
    }

    protected void Country_Selected(object sender, EventArgs e)
    {
        this.BindGrid();
    }   
}

Need help please..

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

pandeyis...

0 4

Reply
ANSWER
User: pandeyism
Replied: on Jun 19, 2018 08:38 AM
Report

Hi sindiyen,

Please take reference the below code and correct your code.

SQL

CREATE TABLE CustomerStatus 
(
    EmployeeID INT, 
    Name VARCHAR(20), 
    IsSendBack Varchar(10)
)
GO

HTML

<asp:GridView ID="gvCustomerStatus" runat="server" CssClass="form-control" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="CustomerID" HeaderText="CustomerID" />
        <asp:BoundField DataField="Name" HeaderText="Name" />
        <asp:TemplateField>
            <ItemTemplate>
                <asp:LinkButton ID="lbIsSendtback" runat="server" Text="Send" OnClick="Send"></asp:LinkButton>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

Namespaces

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

Code

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

private void BindGrid()
{
    string constr = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT * FROM CustomerStatus WHERE IsSendBack IS NULL", con))
        {
            using (SqlDataAdapter da = new SqlDataAdapter(cmd))
            {
                DataTable dt = new DataTable();
                da.Fill(dt);
                this.gvCustomerStatus.DataSource = dt;
                this.gvCustomerStatus.DataBind();
            }
        }
    }
}

protected void Send(object sender, EventArgs e)
{
    LinkButton lbSend = (LinkButton)sender;
    GridViewRow row = lbSend.NamingContainer as GridViewRow;
    int customerId = Convert.ToInt32(row.Cells[0].Text);
    string constr = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("UPDATE CustomerStatus SET IsSendback =@IsSendBack WHERE CustomerId = @CustomerId", con))
        {
            con.Open();
            cmd.Parameters.AddWithValue("@IsSendBack", "true");
            cmd.Parameters.AddWithValue("@CustomerId", customerId);
            cmd.ExecuteNonQuery();
            con.Close();
        }
    }
    this.BindGrid();
}

Screenshot

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

Hide row in GridView on LinkButton click in ASP.Net

Company

Explore

Follow us

Contact Us