基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using WinHtmlEditor;
using System.Data.OleDb;
using System.IO;

namespace MailSending
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            //初始化邮箱服务器
            //Dictionary<string, int> dicList = new Dictionary<string, int>();
            //dicList.Add("smtp.qq.com", 25);
            //dicList.Add("smtp.163.com", 25);
            //dicList.Add("smtp.mail.yahoo.com", 25);
            //dicList.Add("smtp.126.com", 25);
            //dicList.Add("smtp.sina.com", 25);
            //dicList.Add("smtp.sohu.com", 25);
            //dicList.Add("smtp.gmail.com", 25);
            //foreach (var item in dicList)
            //{
            //    ddlList.Items.Add(item.Key);
            //}
            //ddlList.SelectedIndex = 0;


            //初始化皮肤
            //skinEngine1.SkinFile = "Skins\\PageColor2.ssk";
            //skinEngine1.SkinFile = "Skins\\CalmnessColor1.ssk";
            //skinEngine1.SkinFile = "Skins\\CalmnessColor2.ssk";

            skinEngine1.SkinFile = "Skins\\WarmColor1.ssk";
           
            skinEngine1.AddForm(this);

            this.htmlEditor1.BodyInnerHTML = "";
            //this.editor.FontName = new FontFamily("Arial");
            //this.editor.FontSize = FontSize.Seven;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //固定只能看表格
            openFileDialog1.Filter = "Microsoft Excel files(*.xls)|*.xls;*.xlsx";
            openFileDialog1.InitialDirectory = Application.StartupPath;
            //路径选择
            DialogResult dr = openFileDialog1.ShowDialog();
            if (dr == DialogResult.OK)
            {
                string filepath = openFileDialog1.FileName;
                string fullname = filepath.Substring(filepath.LastIndexOf(@"\")   1);
                string filename = fullname.Substring(0, fullname.LastIndexOf("."));

                //路径添加到textBox
                textBox1.Text = filepath;

                #region 读取相应的表名的Excel文件中数据到当前DataGridview中显示

                string strConn = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;"   "Data Source={0};"   "Extended Properties='Excel 8.0;HDR=NO;IMEX=1';", textBox1.Text.Trim());
                if ((System.IO.Path.GetExtension(textBox1.Text.Trim())).ToLower() == ".xls")
                {
                    strConn = "Provider=Microsoft.Jet.OLEDB.4.0;"   "data source="   textBox1.Text.Trim()   ";Extended Properties=Excel 5.0;Persist Security Info=False";
                    //sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="   txtFilePath.Text.Trim()   ";Extended Properties=\"Excel 8.0;HDR="   strHead   ";IMEX=1\"";  
                }

                using (OleDbConnection oleDbConn = new OleDbConnection(strConn))
                {
                    oleDbConn.Open();
                    DataTable dt = oleDbConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
                    //判断是否cmb中已有数据，有则清空  
                    comboBox1.DataSource = null;
                    comboBox1.Items.Clear();
                    //遍历dt的rows得到所有的TABLE_NAME，并Add到cmb中  
                    foreach (DataRow drow in dt.Rows)
                    {
                        comboBox1.Items.Add((String)drow["TABLE_NAME"]);
                    }
                    if (comboBox1.Items.Count > 0)
                    {
                        comboBox1.SelectedIndex = 0;
                    }
                }

                getExcelDataByTableName(comboBox1.Text.Trim(), strConn);

                #endregion

            }
        }

        //按Excel表名查询表下所有数据
        public void getExcelDataByTableName(string sTableName, string strConn)
        {
            OleDbConnection ole = null;
            OleDbDataAdapter da = null;
            DataTable dtShow = null;
            string strExcel = "select * from ["   sTableName   "]";
            try
            {
                ole = new OleDbConnection(strConn);
                ole.Open();
                da = new OleDbDataAdapter(strExcel, ole);
                dtShow = new DataTable();
                da.Fill(dtShow);

                this.dataGridView1.DataSource = dtShow;

                int j = 0;
                dataGridView1.Rows[j].HeaderCell.Value = "序号";
                for (int i = 0; i < dataGridView1.Rows.Count; i  )
                {
                    j = i   1;
                    dataGridView1.Rows[i].HeaderCell.Value = j.ToString();
                }

                //因为生成Excel的时候第一行是标题，所以要做如下操作：  
                //1.修改DataGridView列头的名字，  
                //2.数据列表中删除第一行  
                //int aaa = dtShow.Columns.Count;
                //for (int i = 0; i < dtShow.Columns.Count; i  )
                //{
                //    //dgvdata.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;  
                //    //dgvdata.Columns[i].Name = dt.Columns[i].ColumnName;  
                //    dataGridView1.Columns[i].HeaderCell.Value = dtShow.Rows[0][i].ToString();//c# winform 用代码修改DataGridView列头的名字，设置列名,修改列名  
                //}
                //DataGridView删除行  
                //dataGridView1.Rows.Remove(dataGridView1.Rows[0]);//删除第一行  
                //dgvdata.Rows.Remove(dgvdata.CurrentRow);//删除当前光标所在行  
                //dgvdata.Rows.Remove(dgvdata.Rows[dgvdata.Rows.Count - 1]);//删除最后一行  
                //dgvdata.Rows.Clear();//删除所有行  
                ole.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                if (ole != null)
                    ole.Close();
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            if (txtSendUser.Text.Trim().Length == 0 || txtSendUserPwd.Text.Trim().Length == 0)
            {
                MessageBox.Show("发件人和密码不能为空!"); return;
            }
            if (who.Text.Trim().Length==0 || txtTitle.Text.Trim().Length == 0)
            {
                MessageBox.Show("中文名称和标题不能为空!"); return;
            }
            int conut = this.dataGridView1.Rows.Count;
            int bb = 0;
            int cc = 0;
            for (int i = 0; i < conut-1; i  )
            {
                //获取发送内容
               string content = this.dataGridView1.Rows[i].Cells[0].Value.ToString().Trim();
               //判断邮箱类型  dicList.Add("smtp.qq.com", 25);
               //dicList.Add("smtp.163.com", 25);
               //dicList.Add("smtp.mail.yahoo.com", 25);
               //dicList.Add("smtp.126.com", 25);
               //dicList.Add("smtp.sina.com", 25);
               //dicList.Add("smtp.sohu.com", 25);
               //dicList.Add("smtp.gmail.com", 25);
               string smtp = "";
               if (txtSendUser.Text.Contains("@qq.com"))
               {
                   smtp = "smtp.qq.com";
               }
               else if (txtSendUser.Text.Contains("@163.com"))
               {
                   smtp = "smtp.163.com";

               }
               else if (txtSendUser.Text.Contains("@126.com"))
               {
                   smtp = "smtp.126.com";

               }
               else if (txtSendUser.Text.Contains("@sina.com"))
               {
                   smtp = "smtp.sina.com";

               }
               else if (txtSendUser.Text.Contains("@sohu.com"))
               {
                   smtp = "smtp.sohu.com";

               }
               else if (txtSendUser.Text.Contains("@mail.yahoo.com"))
               {
                   smtp = "smtp.mail.yahoo.com";

               }
               else if (txtSendUser.Text.Contains("@gmail.com"))
               {
                   smtp = "smtp.gmail.com";

               }
                //滚动到发送的行
               this.dataGridView1.CurrentCell= this.dataGridView1.Rows[i].Cells[0];
                //设置行样式为红色
               this.dataGridView1.Rows[i].Cells[0].Style.BackColor = Color.Red;
                //发送邮件
               bool flag = MailHelper.SendMail(txtSendUser.Text, who.Text, txtSendUser.Text, txtSendUserPwd.Text, txtTitle.Text, htmlEditor1.BodyInnerHTML, content, openFileDialog1, smtp, null);
               //判断记录发送成功和发送失败的数量
                if (flag)
                {
                    bb  ;
                }
                else
                {
                    cc  ;
                }
           
               }
            MessageBox.Show("发送完成！共发送" (bb cc) "条！成功：" bb "条！失败：" cc "条！");
            //bool flag = MailHelper.SendMail(txtSendUser.Text, txtSendUser.Text, txtSendUser.Text, txtSendUserPwd.Text, txtTitle.Text, htmlEditor1.BodyInnerHTML, txtRecvierUser.Text, openFileDialog1, ddlList.Text, null);
           
            //if (flag)
            //{
            //    MessageBox.Show("发送成功！");
            //}
            //else
            //{
            //    MessageBox.Show("发送失败！");
            //}
        }

        //private void dataGridView1_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e)
        //{
        //    Rectangle rectangle = new Rectangle(e.RowBounds.Location.X, e.RowBounds.Location.Y, dataGridView1.RowHeadersWidth - 4, e.RowBounds.Height);

        //    TextRenderer.DrawText(e.Graphics, (e.RowIndex   1).ToString(), dataGridView1.RowHeadersDefaultCellStyle.Font, rectangle,
        //    dataGridView1.RowHeadersDefaultCellStyle.ForeColor,
        //    TextFormatFlags.VerticalCenter | TextFormatFlags.Right);
        //}

    }
}