CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Join Date
    Dec 2010
    Posts
    11

    Creiate a Timer / Stopwatch that records to SQL ?

    Can anyone point me in the direction of C# code that would have a start/stop button that would record start to finish and then store that into a SQL table. It sounds pretty basic, but I am super new to C#. Any help appreciated.

  2. #2
    Join Date
    Dec 2010
    Posts
    11

    Re: Creiate a Timer / Stopwatch that records to SQL ?

    bump? no pointers?

  3. #3
    Arjay's Avatar
    Arjay is offline Moderator / EX MS MVP Power Poster
    Join Date
    Aug 2004
    Posts
    13,490

    Re: Creiate a Timer / Stopwatch that records to SQL ?

    Break the problem into pieces. First write the code that creates a start and stop button on a form and write the event handlers for each button.
    Next, add the timer code and to get the timer to start on button start and stop the time when the button stop is pressed.
    Finally, add the sql code to save the values into the database.

  4. #4
    Join Date
    Feb 2011
    Location
    United States
    Posts
    1,016

    Re: Creiate a Timer / Stopwatch that records to SQL ?

    Which flavor of DB? MySQL? Postgres? MS SQL Server?
    Best Regards,

    BioPhysEngr
    http://blog.biophysengr.net
    --
    All advice is offered in good faith only. You are ultimately responsible for effects of your programs and the integrity of the machines they run on.

  5. #5
    Join Date
    Feb 2011
    Location
    United States
    Posts
    1,016

    Re: Creiate a Timer / Stopwatch that records to SQL ?

    Quote Originally Posted by Sentinelace View Post
    bump? no pointers?
    Also, here are some pointers: https://xkcd.com/138/
    Best Regards,

    BioPhysEngr
    http://blog.biophysengr.net
    --
    All advice is offered in good faith only. You are ultimately responsible for effects of your programs and the integrity of the machines they run on.

  6. #6
    Join Date
    Dec 2010
    Posts
    11

    Re: Creiate a Timer / Stopwatch that records to SQL ?

    Here is my code so far. All I think I need is two fileds. The database is Microsoft SQL 2008 R2. I want two fields one with username and other with the end result of the timer. Timer is working, just need to assign to a database now

    using System;
    using System.Drawing;
    using System.Collections;
    using System.ComponentModel;
    using System.Windows.Forms;
    using System.Data;
    using System.Text;

    namespace stopwatch
    {
    /// <summary>
    /// Summary description for Form1.
    /// </summary>
    public class NextGenTimer : System.Windows.Forms.Form
    {
    DateTime da ;
    private System.Windows.Forms.Label label1;
    private System.Windows.Forms.Button button1;
    private System.Windows.Forms.Timer timer1;
    private Label Ver;
    private PictureBox pictureBox1;
    private System.ComponentModel.IContainer components;

    public NextGenTimer()
    {
    //
    // Required for Windows Form Designer support
    //
    InitializeComponent();

    //
    // TODO: Add any constructor code after InitializeComponent call
    //
    }

    /// <summary>
    /// Clean up any resources being used.
    /// </summary>
    protected override void Dispose( bool disposing )
    {
    if( disposing )
    {
    if (components != null)
    {
    components.Dispose();
    }
    }
    base.Dispose( disposing );
    }

    #region Windows Form Designer generated code
    /// <summary>
    /// Required method for Designer support - do not modify
    /// the contents of this method with the code editor.
    /// </summary>
    private void InitializeComponent()
    {
    this.components = new System.ComponentModel.Container();
    System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(NextGenTimer));
    this.label1 = new System.Windows.Forms.Label();
    this.button1 = new System.Windows.Forms.Button();
    this.timer1 = new System.Windows.Forms.Timer(this.components);
    this.Ver = new System.Windows.Forms.Label();
    this.pictureBox1 = new System.Windows.Forms.PictureBox();
    ((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).BeginInit();
    this.SuspendLayout();
    //
    // label1
    //
    this.label1.BackColor = System.Drawing.SystemColors.ControlLightLight;
    this.label1.Font = new System.Drawing.Font("Harrington", 18F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
    this.label1.ForeColor = System.Drawing.Color.DarkBlue;
    this.label1.Location = new System.Drawing.Point(16, 16);
    this.label1.Name = "label1";
    this.label1.Size = new System.Drawing.Size(224, 56);
    this.label1.TabIndex = 0;
    this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
    this.label1.Click += new System.EventHandler(this.label1_Click);
    //
    // button1
    //
    this.button1.Font = new System.Drawing.Font("Microsoft Sans Serif", 15.75F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(178)));
    this.button1.Location = new System.Drawing.Point(12, 78);
    this.button1.Name = "button1";
    this.button1.Size = new System.Drawing.Size(223, 40);
    this.button1.TabIndex = 1;
    this.button1.Text = "Start";
    this.button1.Click += new System.EventHandler(this.button1_Click);
    //
    // timer1
    //
    this.timer1.Interval = 1;
    this.timer1.Tick += new System.EventHandler(this.timer1_Tick);
    //
    // Ver
    //
    this.Ver.AutoSize = true;
    this.Ver.Location = new System.Drawing.Point(196, 153);
    this.Ver.Name = "Ver";
    this.Ver.Size = new System.Drawing.Size(44, 13);
    this.Ver.TabIndex = 2;
    this.Ver.Text = "Ver. 1.0";
    //
    // pictureBox1
    //
    this.pictureBox1.Image = global::stopwatch.Properties.Resources.next;
    this.pictureBox1.Location = new System.Drawing.Point(1, 124);
    this.pictureBox1.Name = "pictureBox1";
    this.pictureBox1.Size = new System.Drawing.Size(153, 41);
    this.pictureBox1.TabIndex = 3;
    this.pictureBox1.TabStop = false;
    this.pictureBox1.Click += new System.EventHandler(this.pictureBox1_Click);
    //
    // NextGenTimer
    //
    this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
    this.BackColor = System.Drawing.SystemColors.ScrollBar;
    this.ClientSize = new System.Drawing.Size(254, 167);
    this.Controls.Add(this.pictureBox1);
    this.Controls.Add(this.Ver);
    this.Controls.Add(this.button1);
    this.Controls.Add(this.label1);
    this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.Fixed3D;
    this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
    this.MaximizeBox = false;
    this.Name = "NextGenTimer";
    this.Text = "StopWatch";
    ((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).EndInit();
    this.ResumeLayout(false);
    this.PerformLayout();

    }
    #endregion

    /// <summary>
    /// The main entry point for the application.
    /// </summary>
    [STAThread]
    static void Main()
    {
    Application.Run(new NextGenTimer());
    }

    private void timer1_Tick(object sender, System.EventArgs e)
    {
    TimeSpan span = DateTime.Now.Subtract(da);
    this.label1.Text = span.Hours.ToString() + " : " + span.Minutes.ToString() + " : " + span.Seconds.ToString() + " : "
    + span.Milliseconds.ToString();
    }

    private void button1_Click(object sender, System.EventArgs e)
    {
    if(this.timer1.Enabled)
    {
    timer1.Stop();
    button1.Text = "Start";
    }
    else
    {
    da = DateTime.Now;
    timer1.Start();
    button1.Text = "Stop";
    }
    }



    private void button2_Click(object sender, EventArgs e)
    {
    }
    private void lnkReset_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
    {


    }

    private void label1_Click(object sender, EventArgs e)
    {

    }

    private void pictureBox1_Click(object sender, EventArgs e)
    {

    }
    }
    }

  7. #7
    Join Date
    Apr 2010
    Posts
    131

    Re: Creiate a Timer / Stopwatch that records to SQL ?

    A typical sql insert would look like this. You can add as many parameters as needed and name them anything you want, and they can be of any datatype (I'm using strings here):

    add using System.Data.SQLClient to your list of references

    Code:
    //your provider string may look something like this
    string myProviderString = @"Data Source=WIN7-PC\MAINSQLSERVER2K8;Initial Catalog=Movies;Integrated Security=True";
    void insertDBRecord(string thingOne, string thingTwo, string thingThree){
      using(SQLConnection conn = new SQLConnection(myProviderString)){
         SqlCommand com = conn.CreateCommand();
         com.Parameters.AddWithValue("@thing1",thingOne);
        com.Parameters.AddWithValue("@thing2",thingTwo);
        com.Parameters.AddWithValue("@thing3",thingThree);
        com.CommandText = "Insert into mytable (col1,col2,col3) values (@thing1,@thing2,@thing3)";
        conn.Open();
        com.ExecuteNonQuery();
        conn.Close();
        }
    }
    com.Paramters.Add(paramName,paramValue) can take any type of data (string, int, double, DateTime, etc) - the only time you need to worry about formatting or conversion is if your c-sharp datatype doesn't match your sql datatype for the same item. Basically, don't worry about it unless SQL throw an error.

    Hope this helps.

  8. #8
    Join Date
    Dec 2010
    Posts
    11

    Re: Creiate a Timer / Stopwatch that records to SQL ?

    how can I change my button to "not" reset every time it is stopped. Meaning, I want to hit stop so the time is still there. Then create a second button to reset

  9. #9
    Join Date
    Apr 2010
    Posts
    131

    Re: Creiate a Timer / Stopwatch that records to SQL ?

    I don't see where label1.Text (the timer) is changed. I'm guessing you want to leave the time in the label, so look for your stop button onclick event and follow the logic to see where it changes label1.text. change that line of code so that label1.text is left intact after the stop button is clicked.

  10. #10
    Join Date
    Dec 2010
    Posts
    11

    Re: Creiate a Timer / Stopwatch that records to SQL ?

    well I'm still learning. I have an all in one button. Now they want a start button, stop button, and a reset button. Once I get that I need to start recording that data into SQL

  11. #11
    Join Date
    Apr 2010
    Posts
    131

    Re: Creiate a Timer / Stopwatch that records to SQL ?

    Once you get all that done, repost your code and I'll help if you still have problems.

  12. #12
    Join Date
    Dec 2010
    Posts
    11

    Re: Creiate a Timer / Stopwatch that records to SQL ?

    will do. Trying not to get my hand held the whole way through this.

  13. #13
    Arjay's Avatar
    Arjay is offline Moderator / EX MS MVP Power Poster
    Join Date
    Aug 2004
    Posts
    13,490

    Re: Creiate a Timer / Stopwatch that records to SQL ?

    If you can, please remove the debug and release folders from the source code, zip up the whole solution and post it here.

    That way it's more convenient for folks trying to help - they just simply have to unzip and load the solution (instead of creating a new solution and pasting your code in).

  14. #14
    Join Date
    Dec 2010
    Posts
    11

    Re: Creiate a Timer / Stopwatch that records to SQL ?

    How do I do that LOL? sorry I am new. I am just pasting the code on my screen in.

    ON the other note: I am having issues separating the buttons

  15. #15
    Arjay's Avatar
    Arjay is offline Moderator / EX MS MVP Power Poster
    Join Date
    Aug 2004
    Posts
    13,490

    Re: Creiate a Timer / Stopwatch that records to SQL ?

    Do you know how to zip up a program? If not, post back. Otherwise to post an attachment, in the Quick reply window, click "Go Advanced" and the click "Manage Attachments". From there you can upload your zipped file.

    Before zipping be sure to remove the \debug and \release folders from the solution. The files in these folder only increase the size of the zip file and get recreated when you build, so there's no need in including them.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured