automatic alert! - Programmers Heaven

Howdy, Stranger!

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


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()) + "'";
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.