How to pass the grid view values from smtp server mail

Question

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(subbareddy536@gmail.com); mail.Body+= subbareddy536@gmail.com=+EmailAddress From +Password=+password from NewStudentRegistrationForm +; mail.Body += Please check below data ; //mail.Body=subbareddy536@gmail.com=+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(subbareddy536@gmail.com); smtp.Credentials = new System.Net.NetworkCredential(subbareddy536@gmail.com 996179); //Or use your Smtp Email ID and Password if Host is not Gmail smtp.EnableSsl = true; smtp.Send(mail);

Venkata Subbareddy · Answer

sir if u dont me can u take my system TeamViewer pls

Manoj Bhoir · Answer

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 Subbareddy · Answer

hi manooj  where iam doing Wrong in my source code please suggestion me...

Manoj Bhoir · Answer

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