hi,
i created a gridview in ASP, where as i kept one column as "last updated date" of an employee.
in aspx code i wrote like dis cmd.Parameters.Add("@LastUpdatedDate", DateTime.Now);
wen ever i inserting data the gridview is showing current date and time.
wen ever i try to update the date and time are not yet changing.
dis is the query i wrote
SelectCommand="SELECT * FROM [Employees] order by lastupdateddate desc"
UpdateCommand="update [Employees] Set [EmpId]=@EmpId,[FirstName]=@FirstName,[MI]=@MI,[LastName]=@LastName,[DOB]=@DOB,[DOJ]=@DOJ,[EmailP]=@EmailP,[EmailW]=@EmailW,[PhoneM]=@PhoneM,[PhoneH]=@PhoneH,[PhoneW]=@PhoneW,[Address]=@Address,[Country]=@Country,[State]=@State,[City]=@City where [EmpId]=@EmpId"
pls reply,
Amit Kumar SinghPosted Mar 1, 2016, 8:57 AM
Upendra Pratap ShahiPosted Mar 3, 2016, 9:29 AM
Amit Kumar SinghPosted Mar 2, 2016, 1:55 AM
Upendra Pratap ShahiPosted Mar 1, 2016, 12:42 PM
GetDate()
Amit Kumar SinghPosted Mar 1, 2016, 10:23 AM
Srinivas RaoPosted Mar 1, 2016, 9:35 AM