C#

static public void refresh(DataGridView datagridview)
            
        {
            try
            {
                if (Connection.State == ConnectionState.Closed)
                    Connection.Open();
                MySqlDataAdapter dataadapter = new MySqlDataAdapter("SELECT * FROM suTable", Connection);
                DataTable dt = new DataTable();
                dataadapter.Fill(dt);
                datagridview.DataSource = dt;
              
            }
            catch (MySqlException Exception)
            {
                MessageBox.Show(Exception.ToString());
            }
            finally
            {
                Connection.Close();
            }

try
        {
            SmtpClient client=new SmtpClient("smtp.gmail.com",587);
            MailMessage message = new MailMessage();
            message.From = new MailAddress(txtemail.Text);
            message.To.Add(txtreciever.Text);
            message.Body = txtbody.Text;
            message.Subject = txtsubject.Text;
            client.UseDefaultCredentials = false;
            client.EnableSsl = true;

            if (txtattachment.Text != "")
            {
                message.Attachments.Add(new Attachment(txtattachment.Text));

            }
            client.Credentials = new System.Net.NetworkCredential(txtemail.Text, txtpassword.Text);
            client.Send(message);
            message = null;
            MessageBox.Show("Message Sent");
        }
        catch(Exception ex)
        {
            MessageBox.Show( "Failed to Send Message");
        }