Date from Sqlserver database to Datetime

Fazil Azeez

Hai, I am create a windows form. I stored expiry date in Sql server database name "test" and the table name "exp" have id(primary key) and date attributes. And my program is a button clicks then the usercontrole show. If date expired when show a message box "the app expired" Button1_clicked Datetime dt1= datetime.now; Datetime dt2= expirydate from database If(dt1>dt2) { Messagebox.show("App expired"); } Else { Usercontrole.bringToFront(); } How can get the date from the the "Sqlserver database" to "Datetime dt2". Database name = test Table name= exp

2 Replies

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

Rupesh Kahane8y ago
Plz try below code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

private void button1_Click(object sender, EventArgs e)
  {
   DateTime dt1 = yourDateHere;
   string connetionString;
   SqlConnection cnn;
   connetionString = @"Data Source=XYZ;Initial Catalog=test;"; // if sql server has username password then add => "User ID=sa;Password=demol23" after test
   cnn = new SqlConnection(connetionString);
   cnn.Open();
   SqlCommand cmd;
   SqlDataReader dr;
   sql ="Select dt2 from exp  -- where condition if any";
   cmd = new SqlCommand(sql,connetionString);
   dr = cmd.ExecuteReader();
   if(dt1 > dr.getValue(0))
   {
       MessageBox.Show("Your Msg");
   }
   cnn.Close();
  }
0
Jignesh Kumar8y ago
Please check below code and change as per need.
DateTime currentDate = DateTime.Now;

/// Get Your Expired date stored in Database
DateTime expiredDate = GetExpiredDate(int Id);


DateTime compareDate = Convert.ToDateTime(expiredDate, new CultureInfo("en-GB"));

string message = string.Empty;

if (currentDate > compareDate)
{
    message = "Your message";
}
+1