Hi yati,
Refer the below sample. You need to get the data from database.
<div>
<asp:GridView runat="server" ID="GridView1" AutoGenerateColumns="false" Caption="Original Record">
<Columns>
<asp:BoundField DataField="Job posting" HeaderText="Job posting" />
<asp:BoundField DataField="Functional Area" HeaderText="Functional Area" />
<asp:BoundField DataField="Location" HeaderText="Location" />
<asp:BoundField DataField="Company" HeaderText="Company" />
<asp:BoundField DataField="Published Date" HeaderText="Published Date" DataFormatString="{0:dd/MM/yyyy}" />
<asp:BoundField DataField="End Date" HeaderText="End Date" DataFormatString="{0:dd/MM/yyyy}" />
</Columns>
</asp:GridView>
<br />
<asp:GridView runat="server" ID="GridViewJL" AutoGenerateColumns="false" OnRowDataBound="OnRowDataBound" Caption="After Condition Record">
<Columns>
<asp:BoundField DataField="Job posting" HeaderText="Job posting" />
<asp:BoundField DataField="Functional Area" HeaderText="Functional Area" />
<asp:BoundField DataField="Location" HeaderText="Location" />
<asp:BoundField DataField="Company" HeaderText="Company" />
<asp:BoundField DataField="Published Date" HeaderText="Published Date" DataFormatString="{0:dd/MM/yyyy}" />
<asp:BoundField DataField="End Date" HeaderText="End Date" DataFormatString="{0:dd/MM/yyyy}" />
</Columns>
</asp:GridView>
</div>
Code
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
loadJobList();
}
}
private void loadJobList()
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[6] {
new DataColumn("Job posting"),new DataColumn("Functional Area"),new DataColumn("Location"),
new DataColumn("Company"),new DataColumn("Published Date",typeof(DateTime)),new DataColumn("End Date",typeof(DateTime)) });
dt.Rows.Add("Senior Programmer", "ICT", "Kuala Lumpur", "Sunrise Ent", "11/01/2016", "11/10/2016");
dt.Rows.Add("IT Helpdesk", "ICT", "Kedah", "Plus Sdn Bhd", "11/01/2016", "11/11/2016");
GridView1.DataSource = dt;
GridView1.DataBind();
GridViewJL.DataSource = dt;
GridViewJL.DataBind();
}
protected void OnRowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DateTime publishedDate = Convert.ToDateTime(e.Row.Cells[4].Text);
DateTime endDate = Convert.ToDateTime(e.Row.Cells[5].Text);
if (endDate <= Convert.ToDateTime(DateTime.Now.ToShortDateString()))
{
e.Row.Visible = false;
}
}
}
Output
Original Record
Job posting | Functional Area | Location | Company | Published Date | End Date |
Senior Programmer |
ICT |
Kuala Lumpur |
Sunrise Ent |
01/11/2016 |
10/11/2016 |
IT Helpdesk |
ICT |
Kedah |
Plus Sdn Bhd |
01/11/2016 |
11/11/2016 |
After Condition Record
Job posting | Functional Area | Location | Company | Published Date | End Date |
IT Helpdesk |
ICT |
Kedah |
Plus Sdn Bhd |
01/11/2016 |
11/11/2016 |