Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

automatic alert!

forsaken_88forsaken_88 Posts: 2Member
hey guys!!
i need help with the date time.. since i want to an automatic alert 2 appear once the particular date has come. for ex :


DateTime dt = DateTime.Today.AddMonths(-2).AddDays(-3);

//Today 2 months before and 3 days

for ma software its

DateTime dt = DateTime.Today.AddDays(+3);

bt nw i do nt knw hw 2 compare this with ma database...

{
DateTime dt= Datetime.Today.addDays(+3);
string dr;
string strSql = "SELECt Exp_date FROM tblwarranty Where Exp_Date='" +DateTime.Parse)txtexpdate.Text.ToString()) + "'";
db.OpenSQLConnection();
SqlCommand cmd = new SqlCommand(strsql, db.myConn);
dr = Convert.ToString(dt);
res = cmd.ExecuteQuery();

n den theres an if cond.... bt it aint workin cld sum1 help!!!!
Sign In or Register to comment.