I want save time how much user spend time from start to end in database

Question

0.00/5 (No votes)

See more:

I'm Trying to calculate start and end time and save it to total column spend by the user in data base and it is Saving Like

0:0:0

and following is my code
thanks in advance

C#

mydb db = new mydb();
string st = "";
DateTime dt1 = DateTime.Now;
DateTime dt = DateTime.Now;
protected void Page_Load(object sender, EventArgs e)
{
   if (!IsPostBack)
   {
      st = "insert into tbl_time(time_in) values('" + dt.ToString("hh:mm:ss") + "')";
      db.ExeQuery(st);
   }
}
protected void btn_save_Click(object sender, EventArgs e)
{
   TimeSpan ts = dt1 - dt;
   st = "update tbl_time set time_out='" + dt1.ToString("hh:mm:ss") + "',tot='" + ts + "'";
   int x = db.ExeQuery(st);
   if (x > 0)
   {
      Response.Write("Saved");
   }
   else
   {
      Response.Write("NOt Savd");
   }
}

Posted 13-Feb-15 20:51pm

Member 10637123

Updated 13-Feb-15 21:15pm

Wendelius

v3

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2015-02-13T21:18:00

Do not concatenate values to your SQL statement, instead use SqlParameter[^]

The other thing is that you initialize the dt1 and dt to the same value and never change them. Perhaps the code should look like

C#

...
protected void Page_Load(object sender, EventArgs e)
{
   if (!IsPostBack)
   {
      st = "insert into tbl_time(time_in) values('" + dt.ToString("hh:mm:ss") + "')";
      db.ExeQuery(st);
      dt1 = DateTime.Now;
   }
}
...

Well, actually with parameters the code should look like

C#

...
protected void Page_Load(object sender, EventArgs e)
{
   if (!IsPostBack)
   {
      st = "insert into tbl_time(time_in) values(@timevalue)";       
      // here goes the code that sets the value of parameter @timevalue 
      db.ExeQuery(st);
      dt1 = DateTime.Now;
   }
}
...

Member 10489937 · Answer 2 · 2015-02-15T18:46:00

You can have table having columns Session_Start,Session_End,Total_Time_On_MY_Site.
Insert current time when session starts. Do same on session End. And then calculate Total_Time_On_MY_Site from above two times.
Do you want time spend for guest user??
If yes then when the user session starts get DateTime.Now(); then add to each page Javascript on leave page to know the exact time the user left.. u do the math :)

Member 10637123 · Answer 3 · 2015-02-14T03:15:00

Solution 2

Im getting the same result like 0:0:0 in the Timspan i.e ts

Posted 14-Feb-15 3:15am

Member 10637123

I want save time how much user spend time from start to end in database

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0