Date from Sqlserver database to Datetime

Question

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

Jignesh Kumar · Answer

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" ; }

Rupesh Kahane · Answer

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(); }