关于C# winform从EXCEL导入到SQL库

  /// <summary>
 /// 执行命令 返回行数
  /// </summary>
/// <param name="safeSql"></param>
/// <returns></returns>
        public static object GetOneNote(string safeSql)
        {
            object relust;
            using (SqlCommand command = new SqlCommand(safeSql, Connection))
            {
                command.CommandTimeout = 0;
                relust = command.ExecuteScalar();
            }
            return relust;
        }
 /// <summary>
  /// 选择判断EXCEL的标准格式
  /// </summary>
  /// <returns></returns>
        private static string SetOpenFileAtt()
        {

            OpenFileDialog objOfd = new OpenFileDialog();
            objOfd.Title = "选择Excel";
            objOfd.Filter = "Excel(*.xls)|*.xls";
            DialogResult dr = objOfd.ShowDialog();
            string filePath = "";
            if (dr == DialogResult.OK)
            {
                filePath = objOfd.FileName;

            }
            else
            {
                filePath = "";
                MessageBox.Show("操作结束", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            return filePath;
        }
/// <summary>
/// 执行命令.执行.EXCEL到SQL的命令
/// </summary>
/// <param name="safeSql"></param>
/// <returns></returns>
        public static int ExecuteCommand(string safeSql)
        {
            int relust = 0;
            using (SqlCommand command = new SqlCommand(safeSql, Connection))
            {
                command.CommandTimeout = 0;
                relust = command.ExecuteNonQuery();
            }
            return relust;
        }

/// <summary>
/// 导入的关键.
/// </summary>
/// <param name="excelColumn"></param>
        public static void ReadXlsToSql(string excelColumn)
        {