Advertisement
Guest User

Untitled

a guest
Dec 4th, 2018
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.03 KB | None | 0 0
  1. private void button3_Click(object sender, EventArgs e)
  2. {
  3. //Recuperation des données
  4. SqlConnection conn = new SqlConnection("Data Source=192.168.206.140;Initial Catalog=Stock;Persist Security Info=True;User ID=sa;Password=abcd4ABCD");
  5.  
  6. SqlDataAdapter sda = new SqlDataAdapter("Select * from [dbo].[Products]", conn);
  7. DataTable dt = new DataTable();
  8. sda.Fill(dt);
  9. dataGridView1.Rows.Clear();
  10. foreach (DataRow item in dt.Rows)
  11. {
  12. int n = dataGridView1.Rows.Add();
  13. dataGridView1.Rows[n].Cells[0].Value = item["ProductCode"].ToString();
  14. dataGridView1.Rows[n].Cells[1].Value = item["ProductName"].ToString();
  15.  
  16. }
  17. Console.WriteLine(dataGridView1);
  18. //preparation de connec
  19. SmtpClient ClientSMTP = new SmtpClient("smtp.laposte.net", 25);
  20.  
  21. ClientSMTP.UseDefaultCredentials = true;
  22.  
  23. ClientSMTP.Credentials = new System.Net.NetworkCredential("vincent.vialla@laposte.net", "Vincent340099");
  24.  
  25. ClientSMTP.DeliveryMethod = SmtpDeliveryMethod.Network;
  26.  
  27. ClientSMTP.EnableSsl = true;
  28.  
  29.  
  30.  
  31. MailMessage Mymail = new MailMessage();
  32. const string SUBJECT = "List of products";
  33. const string BODY = "test";
  34.  
  35. //Expéditeur
  36. Mymail.From = new MailAddress("vincent.vialla@laposte.net", "Mon site Internet");
  37.  
  38. //Destinataire
  39. Mymail.To.Add(new MailAddress("vincent.vialla@laposte.net"));
  40.  
  41. // Contenue du mail
  42. Mymail.Subject = SUBJECT;
  43. Mymail.Body = BODY;
  44.  
  45. try
  46. {
  47. ClientSMTP.Send(Mymail);
  48. Console.WriteLine("Email envoyé");
  49. }
  50. catch (Exception ex)
  51. {
  52. Console.WriteLine("Erreur d'envoi du mail");
  53. Console.WriteLine(ex.Message);
  54. }
  55. }
  56. }
  57. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement