How to compare system date with database date?

[shakir baksh]

how to compare a current system date with a database entry(date) pls explain in code,to be used in the indicator.

[Frinavale]

Well first you need to retrieve the date from the database. If you don't know how to do this then check out the article about How to use a database in your program.


When you do this be sure to use the DateTime Parsing Methods to convert the date retrieved into something that you can use to compare to the systems DateTime.

Then use the DateTime.Now property to retrieve the system's date....

-Frinny

[adriancs]

Here is any example of comparing Database of MySQL with C# datetime:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
 
namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
 
        private void button1_Click(object sender, EventArgs e)
        {
            string conn = "server=localhost;user=root;password=qwerty;database=customer;";
            MySqlConnection myconn = new MySqlConnection(conn);
            string sql = "SELECT `date` FROM `member` WHERE `memberid` = '1';";
            MySqlDataAdapter da = new MySqlDataAdapter(sql, myconn);
            DataTable dt = new DataTable();
            da.Fill(dt);
 
            if (dt.Rows.Count == 0)
            {
                MessageBox.Show("No data found.", "No Data");
            }
            else
            {
                try
                {
                    DateTime dtimeNow = DateTime.Now;
                    DateTime dtimeDB = Convert.ToDateTime(dt.Rows[0][0]);
 
                    if (dtimeDB == dtimeNow)
                    {
                        // Do something...
                    }
                    else if (dtimeDB > dtimeNow)
                    {
                        // Do something...
                    }
                    else if (dtimeDB < dtimeNow)
                    {
                        // Do something...
                    }
                    else
                    { }
                }
                catch (Exception ex) // Capture any error occur
                {
                    MessageBox.Show(ex.ToString());
                }
            }
        }
    }
}