protected void send_mail() { try { DataSet ds = new DataSet(); ds = objOdbc.getDataSet("Select a.my_sponsar_id, a.password, a.trans_pwd, b.username, b.email from mlm_login a,mlm_personal_details b where a.userid=b.userid AND a.my_sponsar_id='" + txtUserID.Text + "'"); if (ds.Tables[0].Rows.Count > 0) { } string strEmailID = ds.Tables[0].Rows[0][4].ToString(); string strPassword = ds.Tables[0].Rows[0][1].ToString(); string strUserName = ds.Tables[0].Rows[0][3].ToString(); string strMailBody = getVerificationOTPMail(strUserName, strPassword); objMail.sendMailSendGrid(strEmailID, strUserName, "*****@*****.**", "LifeGold", "Your Password is", strMailBody); } catch (Exception ex) { } }
protected void send_mail() { try { DataSet ds = new DataSet(); ds = objOdbc.getDataSet("Select a.my_sponsar_id, a.password, a.trans_pwd, b.username, b.email from mlm_login a,mlm_personal_details b where a.userid=b.userid AND a.userid =" + Session["WelcomeID"] + ""); if (ds.Tables[0].Rows.Count > 0) { string strUserID = ds.Tables[0].Rows[0][0].ToString(); string strPassword = ds.Tables[0].Rows[0][1].ToString(); string strTPassword = ds.Tables[0].Rows[0][2].ToString(); string strUserName = ds.Tables[0].Rows[0][3].ToString(); string strEmailID = ds.Tables[0].Rows[0][4].ToString(); string strMailBody = getVerificationOTPMail(strUserID, strPassword, strTPassword, strUserName, strEmailID); objMail.sendMailSendGrid(strEmailID, strUserName, "*****@*****.**", "LifeGold", "LifeGold Registration", strMailBody); } } catch (Exception ex) { } }