I have made use of AJAX Calendar and TimePicker control.
HTML
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<%@ Register Assembly="TimePicker" Namespace="MKB.TimePicker" TagPrefix="Tp1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
body
{
font-family: Arial;
font-size: 10pt;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<cc1:ToolkitScriptManager ID="ScriptManager1" runat="server">
</cc1:ToolkitScriptManager>
<div>
<table border="0" cellpadding="0" cellspacing="0" width="30%">
<tr>
<td>
Name:
</td>
<td>
<asp:TextBox ID="txtName" runat="server" />
</td>
</tr>
<tr>
<td>
In Date:
</td>
<td>
<asp:TextBox ID="txtDate" runat="server" />
<asp:Image ID="imgCalendar" ImageUrl="~/Images/Calendar.png" runat="server" />
<cc1:CalendarExtender ID="ceDate" runat="server" TargetControlID="txtDate" BehaviorID="ceDate"
PopupButtonID="imgCalendar">
</cc1:CalendarExtender>
</td>
</tr>
<tr>
<td>
In Time:
</td>
<td>
<Tp1:TimeSelector ID="tsTime" runat="server">
</Tp1:TimeSelector>
</td>
</tr>
<tr>
<td>
</td>
<td>
<asp:Button ID="btnSubmit" Text="Submit" OnClick="Submit" runat="server" />
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
Namespaces
using System.Configuration;
using System.Data.SqlClient;
Code
protected void Submit(object sender, EventArgs e)
{
string name = txtName.Text.Trim();
DateTime time = DateTime.Parse(string.Format("{0}:{1}:{2} {3}", tsTime.Hour, tsTime.Minute, tsTime.Second, tsTime.AmPm));
DateTime date = Convert.ToDateTime(txtDate.Text.Trim());
string conString = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
string query = "INSERT INTO LogTime(Name, InTime, InDate) VALUES (@Name, @InTime, @InDate)";
using (SqlCommand cmd = new SqlCommand(query, con))
{
cmd.Parameters.AddWithValue("@Name", name);
cmd.Parameters.AddWithValue("@InTime", time);
cmd.Parameters.AddWithValue("@InDate", date);
cmd.ExecuteNonQuery();
}
}
}
}
Table
CREATE TABLE [dbo].[LogTime](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](50) NULL,
[InTime] [time](7) NULL,
[InDate] [date] NULL
) ON [PRIMARY]
GO
Screenshots
