how to get gridview data into label ?

Question

i have a gridview of 5 columns 4th and 5th column are start date and end date respectively i have a label outside gridview i want to calculate this two fiels and bring the duration thanks subin

Subin Thomas · Answer

i used DATEDIFF which takes 3 parameters DATEDIFF(month/year/date, Startdate, EndDate) and the problem is solved well thanks jignesh

Amit Mohanty · Answer

Hi, If you want the result in hours then try this. public decimal getTimeDiff(string dateOne, string dateTwo) { string startTime = DateTime.Parse(dateOne).ToString( "HH:mm:ss" ); string endTime = DateTime.Parse(dateTwo).ToString( "HH:mm:ss" ); TimeSpan returnVal = DateTime.Parse(endTime).Subtract(DateTime.Parse(startTime)); return ( decimal )returnVal.TotalHours; }

Jignesh Kumar · Answer

Hi Subin, Please find reference link, https://www.aspforums.net/Threads/295262/Calculate-difference-between-In-Time-and-Out-Time-in-GridView-ASPNet/

Subin Thomas · Answer

actually i have two options so i think this will be simple

Jignesh Kumar · Answer

But in above question you wrote like you want label out side of grid that why question comes, if you take out side of grid then only it will be for only one record so how do you want it ?

Subin Thomas · Answer

hey jignesh suppose i have => name ,startdate,enddate in my database and when i fetch the records i dont want startdate and enddate i want => name , duration this duration will contain calculation of startdate and end date from the database in a gridview

Jignesh Kumar · Answer

Hi Subin, Your question is not cleare. please add few more details like when you click on any row then you want duration in lalbel ? Or What are you looking for output ?

how to get gridview data into label ?

Answers (7)