date validations
Posted by: RegexLib.com - Recent Patterns,
on 01 Oct 2008 |
View original | Bookmarked: 0 time(s)
if (RadDatePicker1.SelectedDate == System.DateTime.Now.Date)
{
string strconnection;
strconnection = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
SqlConnection cn = new SqlConnection(strconnection);
SqlCommand cmd = new SqlCommand("empattendancedetails", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@empid", SqlDbType.Int).Direction = ParameterDirection.Input;
cmd.Parameters.Add("@date", SqlDbType.DateTime).Direction = ParameterDirection.Input;
cmd.Parameters.Add("@intime", SqlDbType.DateTime).Direction = ParameterDirection.Input;
cmd.Parameters.Add("@outtime", SqlDbType.DateTime).Direction = ParameterDirection.Input;
cmd.Parameters["@empid"].Value = Session["loginid"];
cmd.Parameters["@date"].Value = RadDatePicker1.SelectedDate.ToString();
cmd.Parameters["@intime"].Value = RadTimePicker1.SelectedDate.ToString();
cmd.Parameters["@outtime"].Value = RadTimePicker2.SelectedDate.ToString();
cn.Open();
cmd.ExecuteNonQuery();
cn.Close(); Response.Write("Record Added.");
}
else
Response.Write("enter todays date");
}