<asp:datalist id='DataList1' OnItemDataBound ='ItemDB' GridLines='Both' RepeatColumns='2' runat='server' ShowHeader='true'>
<HeaderStyle Font-Bold='True' HorizontalAlign='Center' Font-Name='verdana' Font-Size='10pt'></HeaderStyle>
<ItemStyle Font-Size='10pt'></ItemStyle>
<Headertemplate>
Employee Details
</Headertemplate>
<ItemTemplate>
<%#DataBinder.Eval(Container.DataItem,'LastName')%>
,
<%#DataBinder.Eval(Container.DataItem,'FirstName')%>
<br>
HireDate :
<%#DataBinder.Eval(Container.DataItem,'HireDate')%>
<br>
</ItemTemplate>
</asp:datalist>
VB.NET
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
’Put user code to initialize the page here
’Populate the DataList with DataSet
End Sub
Protected Sub ItemDB(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataListItemEventArgs) Handles DataList1.ItemDataBound
Dim drv As DataRowView = CType(e.Item.DataItem, DataRowView)
Dim BDate As DateTime
If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem Then
’To check if the BirthDate has null values
If Not drv.Row('BirthDate').ToString = DBNull.Value.ToString Then
’Assign the BirthDate to variable BDate
BDate = DateTime.Parse(drv.Row('BirthDate').ToString)
End If
’If the Employee BirthDay is Today
’Change the row Text Color to blue
If BDate.ToString('dd/MM') = DateTime.Now.ToString('dd/MM') Then
e.Item.ForeColor = Color.Blue
e.Item.Font.Bold = True
End If
End If
End Sub
C#
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
DataList1.DataSource =BindDataClass.BindData ();
DataList1.DataBind ();
}
protected void ItemDB(Object sender , System.Web.UI.WebControls.DataListItemEventArgs e )
{
DataRowView drv = (DataRowView)e.Item.DataItem;
DateTime BDate=Convert.ToDateTime (null) ;
if ((e.Item.ItemType == ListItemType.Item )||( e.Item.ItemType == ListItemType.AlternatingItem))
{ //To check if the BirthDate has null values
if( drv.Row['BirthDate'].ToString() != DBNull.Value.ToString())
{
//Assign the BirthDate to variable BDate
BDate = DateTime.Parse(drv.Row['BirthDate'].ToString());
}
//If the Employee BirthDay is Today
//Change the row Text Color to blue
if (BDate.ToString('dd/MM') == DateTime.Now.ToString('dd/MM'))
{
e.Item.ForeColor = Color.Blue;
e.Item.Font.Bold = true;
}
}
}
Share with