hiding the selected rows in gridview

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

XML

<div>
        <asp:GridView ID="GridView1" runat="server"
               AllowPaging="True"
               DataSourceID="SqlDataSource1"
               AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333">
               <AlternatingRowStyle BackColor="White" />
               <Columns>

                   <asp:TemplateField HeaderText="Select">


                       <ItemTemplate>
                           <asp:CheckBox ID="chkSelect" runat="server"
                               AutoPostBack="true"
                               OnCheckedChanged="chkSelect_CheckedChanged" />
                       </ItemTemplate>

                   </asp:TemplateField>
                   <asp:BoundField DataField="DocketNo" HeaderText="DocketNo"
                       SortExpression="ID" />

                   <asp:TemplateField HeaderText="BranchCode"
                       SortExpression="BranchCode">
                       <ItemTemplate>
                           <asp:TextBox ID="txtBranchCode" runat="server"
                               Text='<%# Bind("BranchCode") %>' ReadOnly="true" Width="50px"
                               ForeColor="Blue" BorderStyle="none"
                               BorderWidth="0px">
                           </asp:TextBox>
                       </ItemTemplate>
                   </asp:TemplateField>


                   <asp:TemplateField HeaderText="Date"
                       SortExpression="Date">
                       <ItemTemplate>
                           <asp:TextBox ID="txtDate" runat="server"
                               Text='<%# Bind("Date") %>'
                               ReadOnly="true" ForeColor="Blue" Width="50px"
                               BorderStyle="none" BorderWidth="0px">
                           </asp:TextBox>
                       </ItemTemplate>
                   </asp:TemplateField>
                       <asp:TemplateField HeaderText="PKTS"
                       SortExpression="PKTS">
                       <ItemTemplate>
                           <asp:TextBox ID="txtPKTS" runat="server"
                               Text='<%# Bind("PKTS") %>' ReadOnly="true" Width="50px"
                               ForeColor="Blue" BorderStyle="none"
                               BorderWidth="0px">
                           </asp:TextBox>
                       </ItemTemplate>
                   </asp:TemplateField>

                   <asp:TemplateField HeaderText="To"
                       SortExpression="To">
                       <ItemTemplate>
                           <asp:TextBox ID="txtTo" runat="server" Width="50px"
                               Text='<%# Bind("To") %>'
                               ReadOnly="true" ForeColor="Blue"
                               BorderStyle="none" BorderWidth="0px">
                           </asp:TextBox>
                       </ItemTemplate>
                   </asp:TemplateField>



                   <asp:TemplateField HeaderText="ActWT"
                       SortExpression="ActWt">
                       <ItemTemplate>
                           <asp:TextBox ID="txtActWt" runat="server"
                               Text='<%# Bind("ActWt") %>'
                               ReadOnly="true" ForeColor="Blue" Width="50px"
                               BorderStyle="none" BorderWidth="0px">
                           </asp:TextBox>
                       </ItemTemplate>
                   </asp:TemplateField>
                    <asp:TemplateField HeaderText="ChargeWt"
                       SortExpression="ChargeWt">
                       <ItemTemplate>
                           <asp:TextBox ID="txtChargeWt" runat="server"
                               Text='<%# Bind("ChargeWt") %>'
                               ReadOnly="true" ForeColor="Blue" Width="50px"
                               BorderStyle="none" BorderWidth="0px">
                           </asp:TextBox>
                       </ItemTemplate>
                   </asp:TemplateField>
                    <asp:TemplateField HeaderText="Mode"
                       SortExpression="Mode">
                       <ItemTemplate>
                           <asp:TextBox ID="Mode" runat="server"
                               Text='<%# Bind("Mode") %>'
                               ReadOnly="true" ForeColor="Blue" Width="50px"
                               BorderStyle="none" BorderWidth="0px">
                           </asp:TextBox>
                       </ItemTemplate>
                   </asp:TemplateField>
                    <asp:TemplateField HeaderText="ChallanNo"
                       SortExpression="ChallanNo">
                       <ItemTemplate>
                           <asp:TextBox ID="txtChallanNo" runat="server"
                               Text='<%# Bind("ChallanNo") %>'
                               ReadOnly="false" ForeColor="Blue" Width="50px"
                               BorderStyle="none" BorderWidth="0px">
                           </asp:TextBox>
                       </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="VehicleNo"
                       SortExpression="VehicleNo">
                       <ItemTemplate>
                           <asp:TextBox ID="VehicleNo" runat="server"
                               Text='<%# Bind("VehicleNo") %>'
                               ReadOnly="False" ForeColor="Blue" Width="50px"
                               BorderStyle="none" BorderWidth="0px">
                           </asp:TextBox>
                       </ItemTemplate>
                   </asp:TemplateField>
                    <asp:TemplateField HeaderText="ChallanDate"
                       SortExpression="ChallanDate">
                       <ItemTemplate>
                           <asp:TextBox ID="txtChallanDate" runat="server"
                               Text='<%# Bind("ChallanDate") %>'
                               ReadOnly="False" ForeColor="Blue" Width="50px"
                               BorderStyle="none" BorderWidth="0px">
                           </asp:TextBox>
                       </ItemTemplate>
                   </asp:TemplateField>

                    <asp:TemplateField HeaderText="Description"
                       SortExpression="Description">
                       <ItemTemplate>
                           <asp:TextBox ID="txtDescription" runat="server"
                               Text='<%# Bind("Description") %>'
                               ReadOnly="False" ForeColor="Blue" Width="50px"
                               BorderStyle="none" BorderWidth="0px">
                           </asp:TextBox>
                       </ItemTemplate>
                        </asp:TemplateField>




               </Columns>
               <EditRowStyle BackColor="#2461BF" />
               <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
               <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
               <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
               <RowStyle BackColor="#EFF3FB" />
               <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
               <SortedAscendingCellStyle BackColor="#F5F7FB" />
               <SortedAscendingHeaderStyle BackColor="#6D95E1" />
               <SortedDescendingCellStyle BackColor="#E9EBEF" />
               <SortedDescendingHeaderStyle BackColor="#4870BE" />
           </asp:GridView>
           SELECT FROM
           <asp:SqlDataSource ID="SqlDataSource1" runat="server"
               ConnectionString="<%$ ConnectionStrings:amitpandeyConnectionString %>"
               SelectCommand="SELECT [Date], [DocketNo], [To], [PKTS], [ActWt], [ChargeWt], [Mode], [BranchCode],[ChallanNo] ,[ChallanDate],[VehicleNo], [Description]   FROM [CreateDocket]"
               DeleteCommand="DELETE FROM product WHERE (DocketNo= @DocketNo)"
               UpdateCommand="UPDATE [CreateDocket] SET [To] = @To,
             [Date] = @Date,[PKTS]=@PKTS,[BranchCode] = @BranchCode,[ActWt] = @ActWt,[ChargeWt]=@ChargeWt,[Mode]=@Mode,[ChallanNo]=@ChallanNo,[ChallanDate]=@ChallanDate,[VehicleNo]=@VehicleNo,[Description]=@Description WHERE [DocketNo] = @DocketNo">
               <DeleteParameters>
                   <asp:Parameter Name="DocketNo" />
               </DeleteParameters>
               <UpdateParameters>
                   <asp:Parameter Name="Date" />
                   <asp:Parameter Name="PKTS" />
                   <asp:Parameter Name="To" />
                   <asp:Parameter Name="BranchCode" />
                   <asp:Parameter Name="ActWt" />
                   <asp:Parameter Name="ChargeWT" />
                   <asp:Parameter Name="Mode" />
                    <asp:Parameter Name="ChallanNo" />
                   <asp:Parameter Name="ChallanDate" />
                   <asp:Parameter Name="VehicleNo" />
                   <asp:Parameter Name="Description" />

               </UpdateParameters>
           </asp:SqlDataSource>

C#

public partial class Admin_CreateChallan : System.Web.UI.Page
{
    string connStr = ConfigurationManager.ConnectionStrings["amitpandeyConnectionString"].ConnectionString;
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        StringBuilder strSql = new StringBuilder(string.Empty);

        SqlConnection con = new SqlConnection(connStr);
        SqlCommand cmd = new SqlCommand();

        for (int i = 0; i < GridView1.Rows.Count; i++)
        {
            CheckBox chkUpdate = (CheckBox)
               GridView1.Rows[i].Cells[0].FindControl("chkSelect");
            if (chkUpdate != null)
            {
                if (chkUpdate.Checked)
                {

                    string strDocketNo = GridView1.Rows[i].Cells[1].Text;

                    string strBranchCode = ((TextBox)GridView1.Rows[i].FindControl("txtBranchCode")).Text;

                    string strDate = ((TextBox)GridView1.Rows[i].FindControl("txtDate")).Text;

                    string strPKTS = ((TextBox)GridView1.Rows[i].FindControl("txtPKTS")).Text;

                    string strTo = ((TextBox)GridView1.Rows[i].FindControl("txtTo")).Text;

                    string strActWt = ((TextBox)GridView1.Rows[i].FindControl("txtActwt")).Text;

                    string strChargeWt = ((TextBox)GridView1.Rows[i].FindControl("txtChargeWt")).Text;

                    string strMode = ((TextBox)GridView1.Rows[i].FindControl("txtMode")).Text;

                    string strChallanNo = ((TextBox)GridView1.Rows[i].FindControl("txtChallanNo")).Text;

                    string strVehicleNo = ((TextBox)GridView1.Rows[i].FindControl("txtVehicleNo")).Text;

                    string strChallanDate = ((TextBox)GridView1.Rows[i].FindControl("txtChallanDate")).Text;

                    string strDescription = ((TextBox)GridView1.Rows[i].FindControl("txtDescription")).Text;

                    string strUpdate = "Update CreateDocket set BranchCode = '" + strBranchCode + "', Date = '" + strDate + "', PKTS = '" + strPKTS + "',To = '" + strTo + "',ActWt = '" + strActWt + "',ChargeWt = '" + strChargeWt + "',Mode = '" + strMode + "',ChallanNo = '" + strChallanNo + "',VehicleNo = '" + strVehicleNo + "',ChallanDate = '" + strChallanDate + "',Description = '" + strDescription + "' WHERE DocketNo ='" + strDocketNo + "'";
                    strSql.Append(strUpdate);
                }
            }
        }
        try
        {
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = strSql.ToString();
            cmd.Connection = con;
            con.Open();
            cmd.ExecuteNonQuery();
        }
        catch (SqlException ex)
        {
            string errorMsg = "Error in Updation";
            errorMsg += ex.Message;
            throw new Exception(errorMsg);
        }
        finally
        {
            con.Close();
        }

    }

    protected void chkSelect_CheckedChanged
                        (object sender, EventArgs e)
    {
        CheckBox chkTest = (CheckBox)sender;
        GridViewRow grdRow = (GridViewRow)chkTest.NamingContainer;

        TextBox txtBranchCode = (TextBox)grdRow.FindControl("txtBranchCode");

        TextBox txtDate = (TextBox)grdRow.FindControl("txtDate");

        TextBox txtPKTS = (TextBox)grdRow.FindControl("txtPKTS");

        TextBox txtTo = (TextBox)grdRow.FindControl("txtTo");

        TextBox txtActWT = (TextBox)grdRow.FindControl("txtActWT");

        TextBox txtChargeWt = (TextBox)grdRow.FindControl("txtChargeWt");

        TextBox txtMode = (TextBox)grdRow.FindControl("txtMode");

        TextBox txtChallanNo = (TextBox)grdRow.FindControl("txtChallanNo");

        TextBox txtVehicleNo = (TextBox)grdRow.FindControl("txtVehicleNo");

        TextBox txtChallanDate = (TextBox)grdRow.FindControl("txtChallanDate");

        TextBox txtDescription = (TextBox)grdRow.FindControl("txtDescription");

        if (chkTest.Checked)
        {

            txtChallanNo.ReadOnly = false;
            txtVehicleNo.ReadOnly = false;
            txtChallanDate.ReadOnly = false;
            txtDescription.ReadOnly = false;
            txtChallanNo.ForeColor = System.Drawing.Color.Red;
            txtVehicleNo.ForeColor = System.Drawing.Color.Red;
            txtChallanDate.ForeColor = System.Drawing.Color.Red;
            txtDescription.ForeColor = System.Drawing.Color.Red;
        }
        else
        {
            txtChallanNo.ReadOnly = true;
            txtVehicleNo.ReadOnly = true;
            txtChallanDate.ReadOnly = true;
            txtDescription.ReadOnly = true;
            txtChallanNo.ForeColor = System.Drawing.Color.Green;
            txtVehicleNo.ForeColor = System.Drawing.Color.Green;
            txtChallanDate.ForeColor = System.Drawing.Color.Green;
            txtDescription.ForeColor = System.Drawing.Color.Green;

        }
    }
}

What I want to do is to hide the rows of the gridviev after selecting the checkboxes and clicking on the submit button

Posted 9-Mar-15 1:39am

Member 11111143

Updated 9-Mar-15 1:53am

RajeeshMenoth

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2015-03-09T02:08:00

Solution 1

So, inside the Event btnUpdate_Click, when you loop for all the Grid Rows, you are already checking if the CheckBox is checked or not.

So, if it is checked, then make it Visible false.

Posted 9-Mar-15 2:08am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Member 11111143 9-Mar-15 8:11am

can u tell me how to code that and put the source

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 9-Mar-15 8:20am

You should try this on your own. Anyways, I am helping...

protected void btnUpdate_Click(object sender, EventArgs e)
{
StringBuilder strSql = new StringBuilder(string.Empty);

SqlConnection con = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand();

for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox chkUpdate = (CheckBox)
GridView1.Rows[i].Cells[0].FindControl("chkSelect");
if (chkUpdate != null)
{
if (chkUpdate.Checked)
{

string strDocketNo = GridView1.Rows[i].Cells[1].Text;

string strBranchCode = ((TextBox)GridView1.Rows[i].FindControl("txtBranchCode")).Text;

string strDate = ((TextBox)GridView1.Rows[i].FindControl("txtDate")).Text;

string strPKTS = ((TextBox)GridView1.Rows[i].FindControl("txtPKTS")).Text;

string strTo = ((TextBox)GridView1.Rows[i].FindControl("txtTo")).Text;

string strActWt = ((TextBox)GridView1.Rows[i].FindControl("txtActwt")).Text;

string strChargeWt = ((TextBox)GridView1.Rows[i].FindControl("txtChargeWt")).Text;

string strMode = ((TextBox)GridView1.Rows[i].FindControl("txtMode")).Text;

string strChallanNo = ((TextBox)GridView1.Rows[i].FindControl("txtChallanNo")).Text;

string strVehicleNo = ((TextBox)GridView1.Rows[i].FindControl("txtVehicleNo")).Text;

string strChallanDate = ((TextBox)GridView1.Rows[i].FindControl("txtChallanDate")).Text;

string strDescription = ((TextBox)GridView1.Rows[i].FindControl("txtDescription")).Text;

string strUpdate = "Update CreateDocket set BranchCode = '" + strBranchCode + "', Date = '" + strDate + "', PKTS = '" + strPKTS + "',To = '" + strTo + "',ActWt = '" + strActWt + "',ChargeWt = '" + strChargeWt + "',Mode = '" + strMode + "',ChallanNo = '" + strChallanNo + "',VehicleNo = '" + strVehicleNo + "',ChallanDate = '" + strChallanDate + "',Description = '" + strDescription + "' WHERE DocketNo ='" + strDocketNo + "'";
strSql.Append(strUpdate);

GridView1.Rows[i].Visible = false;
}
}
}
try
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = strSql.ToString();
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
string errorMsg = "Error in Updation";
errorMsg += ex.Message;
throw new Exception(errorMsg);
}
finally
{
con.Close();
}

}

Member 11111143 9-Mar-15 8:38am

I have one more problem i.e
before the div I have
<div align ="right">
</div>
<div align="center">
<asp:Label ID="lb1" runat="server" Text="Label">

Create Challan

<table border="1" style="border-collapse: collapse; width: 369px;" cellspacing="1">
<tr>
<td width="77" height="16" align="left" >Name:</td>
<td width="77" height="16" align="left" > <asp:Label
ID="lbl_UserName" runat="server" Font-Bold="True"><br /></td>

<td width="77" height="16" align="left" >StaffCode:</td>
<td width="77" height="16" align="left" > <asp:Label
ID="lbl_address" runat="server" Font-Bold="True"><br /></td>

<td width="77" height="16" align="left" >Branch:</td>
<td width="77" height="16" align="left" > <asp:Label
ID="lbl_sal" runat="server" Font-Bold="True"><br /></td>

<td width="77" height="16" align="left" >Designation:</td>
<td width="77" height="16" align="left" > <asp:Label
ID="lbl_phone" runat="server" Font-Bold="True"><br /></td>
<td> <asp:TextBox ID="TextBox1" runat="server">

<script type="text/javascript">
// a startup script to get put everything in motion
window.setTimeout("ShowTime()", 1000);
</script>
</td>
</tr>
</table>
</div>
protected void Page_Load(object sender, EventArgs e)
{
string strConnString = ConfigurationManager.ConnectionStrings["amitpandeyConnectionString"].ConnectionString;
string str;
SqlCommand com;
lb1.Text = "" + "WELLCOME:: " + "" + "" + Session["UserName"] + "";
SqlConnection con = new SqlConnection(strConnString);
con.Open();
str = "select * from Login where UserName='" + Session["UserName"] + "'";
com = new SqlCommand(str, con);
SqlDataAdapter da = new SqlDataAdapter(com);
DataSet ds = new DataSet();
da.Fill(ds);

lbl_address.Text = ds.Tables[0].Rows[0]["UserId"].ToString();
lbl_sal.Text = ds.Tables[0].Rows[0]["Branch"].ToString();
lbl_phone.Text = ds.Tables[0].Rows[0]["Designation"].ToString();
}
What Actually I want is that lbl_sal(label) shows me the branch which I have login I want to show only those rows that will have the same name as in label.Is there any way please suggest me

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 9-Mar-15 13:52pm

First I would tell you mark this as answer. Now you are asking another question. If you want to get only those rows matching with some label text, then with the query attach a where condition to match the name. This is while getting the data from database.

If you don't want to do this, then use RowDataBound Event and inside that check whatever data for the row and match with label txt and hide or show according to your requirements.

Member 11111143 10-Mar-15 0:19am

Initially i use to set SELECT * From [tableName] WHERE BranchCode=lbl_Sal.Text,but overhere I am not understanding where to put the WHERE condition just tell me where shall I put this condition

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 10-Mar-15 4:26am

Add this condition to the select query which retrieves the rows for the grid.