how to get gridview data into label ?

Subin Thomas

7y1.4k.NET

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

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty7y ago
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;
}
Subin Thomas7y ago
i used DATEDIFF which takes 3 parameters

DATEDIFF(month/year/date, Startdate, EndDate)

and the problem is solved
well thanks jignesh
Jignesh Kumar7y ago
Hi Subin,

Please find reference link,

https://www.aspforums.net/Threads/295262/Calculate-difference-between-In-Time-and-Out-Time-in-GridView-ASPNet/
Subin Thomas7y ago
actually i have two options so i think this will be simple
Jignesh Kumar7y ago
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 Thomas7y ago
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 Kumar7y ago
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 ?