Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void button3_Click(object sender, EventArgs e)
- {
- //Recuperation des données
- SqlConnection conn = new SqlConnection("Data Source=192.168.206.140;Initial Catalog=Stock;Persist Security Info=True;User ID=sa;Password=abcd4ABCD");
- SqlDataAdapter sda = new SqlDataAdapter("Select * from [dbo].[Products]", conn);
- DataTable dt = new DataTable();
- sda.Fill(dt);
- dataGridView1.Rows.Clear();
- foreach (DataRow item in dt.Rows)
- {
- int n = dataGridView1.Rows.Add();
- dataGridView1.Rows[n].Cells[0].Value = item["ProductCode"].ToString();
- dataGridView1.Rows[n].Cells[1].Value = item["ProductName"].ToString();
- }
- Console.WriteLine(dataGridView1);
- //preparation de connec
- SmtpClient ClientSMTP = new SmtpClient("smtp.laposte.net", 25);
- ClientSMTP.UseDefaultCredentials = true;
- ClientSMTP.Credentials = new System.Net.NetworkCredential("vincent.vialla@laposte.net", "Vincent340099");
- ClientSMTP.DeliveryMethod = SmtpDeliveryMethod.Network;
- ClientSMTP.EnableSsl = true;
- MailMessage Mymail = new MailMessage();
- const string SUBJECT = "List of products";
- const string BODY = "test";
- //Expéditeur
- Mymail.From = new MailAddress("vincent.vialla@laposte.net", "Mon site Internet");
- //Destinataire
- Mymail.To.Add(new MailAddress("vincent.vialla@laposte.net"));
- // Contenue du mail
- Mymail.Subject = SUBJECT;
- Mymail.Body = BODY;
- try
- {
- ClientSMTP.Send(Mymail);
- Console.WriteLine("Email envoyé");
- }
- catch (Exception ex)
- {
- Console.WriteLine("Erreur d'envoi du mail");
- Console.WriteLine(ex.Message);
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement