How to pass the grid view values from smtp server mail

Venkata Subbareddy

11y1kLearn iOS Programming

Hi Every one ,

i developed one school mangement System here i have small Doubt let me know where i doning mistake...

step 1:

student register our site so the values stored database after the database maintaince Admin

step:2

when Admin Approve the new Student the user mail id goes to username And Password...in the below my code

note: Admin Apporved by using Cheeckbox in itemtemplte..

if (chkStatus.Checked)
{
MailMessage mail = new MailMessage();
SmtpClient smtp = new SmtpClient();
mail.From = new MailAddress("[email protected]");
mail.Body+= "[email protected]="+EmailAddress From +",Password="+password from NewStudentRegistrationForm +"";
mail.Body += "Please check below data

";
//mail.Body="[email protected]="+EmailAddress from +",password="+password from data base +"";
smtp.Port = 587;
smtp.Host = ("smtp.gmail.com"); //You can also use your SMTP Server Address here
smtp.UseDefaultCredentials = false;
mail.To.Add("[email protected]");
smtp.Credentials = new System.Net.NetworkCredential("[email protected]", "996179"); //Or use your Smtp Email ID and Password if Host is not Gmail
smtp.EnableSsl = true;
smtp.Send(mail);

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Venkata Subbareddy11y ago
sir if u dont me can u take my system TeamViewer pls
Manoj Bhoir11y ago
Hi,
Your code is correct. nothing wrong in that. Just for user name and password you wrote in your question it should be retrieve from your database. So, I think you will get your username from your grid view. As i suggested in my answer based on that you can get whatever details you want for that username from your database using normal sql query execution which i hope you know how to do that and then simply pass required details in your mail body and then try to send mail.

var username = from gridview using selectedRow property and Cell value.

Other details you can fetch from database like emailid, password and etc. Save these values in some variable and then pass these variables in your email body.
Here, suppose EmailAddress and password are variables which contains student emailaddress and password details then,
mail.Body+= "You User Id/Email Id = "+EmailAddress +",Password="+password +"";
Venkata Subbareddy11y ago
hi manooj , where iam doing Wrong in my source code please suggestion me...
Manoj Bhoir11y ago
Hi,
On the OnSelectedIndexChanged event handler of the ASP.Net GridView, you can get UserName which is approved by admin. Based on that UserName retrieve User Password from the database and pass this both values in your Email Body. See this sample code :

protected void OnSelectedIndexChanged(object sender, EventArgs e)

{
   if (chkStatus.Checked)
   {

   //Accessing BoundField Column

   string username = GridView1.SelectedRow.Cells[0].Text;

   // Based on this username retrieve password from database if it is not       present in your grid.
       string password = GetUserPassword(username);
      //Now Set this both values in your Email body.

    }
}

For more details check this link :
How to get Selected Row cell value from GridView in ASP.Net
How to get the Values of Selected Row from a Gridview using ASP.NET