Prakash Mondal

Prakash Mondal

  • NA
  • 288
  • 208.9k

How to hide GridView Rows with conditions in ASP.NET C#?

Mar 25 2014 3:20 PM
I want to hide selected day rows in gridview.
 
database table:
 
 
 Design View (Default2.aspx):
 
 Source View:
  <td>
<asp:Button ID="Button1" runat="server" Text="Show" Font-Bold="True"
onclick="Button1_Click" />
</td>
<td>
&nbsp;</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
&nbsp;</td>
<td colspan="2">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">

<Columns>
<asp:TemplateField HeaderText="Selection">
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Days">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%#Eval("DayName") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Time">
<ItemTemplate>
<br />
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</td>
Code View( Default.aspx.cs):
 protected void Button1_Click(object sender, EventArgs e)
{
String[] arr = new String[6];
arr[0] = "Wednesday";
arr[1] = "Friday";
arr[2] = "Saturday";

SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\TestDB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
SqlCommand cmd = new SqlCommand();
SqlDataReader dr;
DataTable DT = new DataTable();
try
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select *from day", con);
da.Fill(DT);
GridView1.DataSource = DT;
GridView1.DataBind();
}
catch (Exception pm)
{

}
finally
{
con.Close();
}
}
 
Output:
 
 But I want to hide those rows which I selected pink background array values.
i.e,
 String[] arr = new String[6];
arr[0] = "Wednesday";
arr[1] = "Friday";
arr[2] = "Saturday";
 
So, only show Monday, Tuesday, Thursday, Sunday rows in gridview.
 
 Please Help Me.
 
 

Answers (5)