SqlCommand cmd = new SqlCommand("select * from leavereminder", db.sqlcon); SqlDataAdapter adp = new SqlDataAdapter(cmd); //create object for datable DataTable dt = new DataTable(); //fill it adp.Fill(dt); //check for more then 0 rows if (dt.Rows.Count > 0) { //status is my column name, here i have checked for the "pending" value if (dt.Rows[0]["status"].ToString() == "pending") { //sending mechanism if satisfied condition sendmail(dt.Rows[0]["email"].ToString(), dt.Rows[0]["name"].ToString()); } }
Sqlconnection con = new sqlconnection(connectionstring); string Query = "select columnname from tablename"; con .Open(); SqlDataAdapter a = new SqlDataAdapter(Query,con); DataTable t = new DataTable(); a.Fill(t);
Thanks & Regards, Santhi .V
Login to post response