Displaying page
of
pages;
Items to
|
Title |
Test
Details
date validations
|
|
Expression |
date
|
|
Description |
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");
}
|
|
Matches |
validation
|
|
Non-Matches |
not validations
|
|
Author |
Rating:
Not yet rated.
vasireddyveenavani
|
|
Title |
Test
Details
examples on storedprocedures
|
|
Expression |
getting username from empid
|
|
Description |
LTER PROCEDURE [dbo].[usernamecheck]
@username varchar(50),
@loginID int = 0 OUTPUT
AS
SELECT @loginID = empid from emp
WHERE username=@username
if @@ROWCOUNT < 1
SELECT @loginID = 0
select @loginID
|
|
Matches |
storedprocedures
|
|
Non-Matches |
not stored procedures
|
|
Author |
Rating:
vasireddyveenavani
|
Displaying page
of
pages;
Items to
