Displaying of current date n time in the gridview n storing it in the database on checking of the checkbox

See more:

ASP.NET

hello friends.,

I want to store the Attended date n time in the database.. I have the 2 separate columns for date n time as nvarchar in the table urbrur.


I have a one gridview in that i have 2columns and one checkbox one is for compno n other for status where the value of status is either Attended or Under Process..

now i'm displaying only under process complaints n on checking of the respective check box the status of the compno is updated as Attended in the database table called urbrur..but now i want to store the current date n time as well in the urbrur as at what date n time that respective copmno is get Attended . .

So how should i display the current date n time in the existing gridview and on checking of that particular check box that date n time also should be get stored in the table urbrur[here i have 2separate columns for date and time as nvarchar]


So kindly plz suggest me to how i do make it . .'m very much indeed needed.



Thx,
praveen