关于接口集的简单问题\ 2 [英] simple question about interface sets\2

问题描述

应用解决方案如下//////////////////////////////////////////////

the app soluion is as follows//////////////////////////////////////////////

推荐答案

Plz检查

Plz check This

Or try the following

Method for obtain a Excel file

private string SelectTextFile()
{
   OpenFileDialog dialog = new OpenFileDialog();
   dialog.Filter = "xls file (*.xls)|*.xls |xlsx file(*.xlsx)|*.xlsx|all file(*.*)|*.*";
   dialog.Title = "Select a File";
   return (dialog.ShowDialog() == DialogResult.OK)
    ? dialog.FileName : null;
}

Excel连接并将数据放入数据表的方法

Method for Excel Connection and putting Data in a Datatable

private void getDataFromXLS(string strFilePath)
{
  string strConn = string.Empty;
  try
   {
    if (System.IO.Path.GetExtension(strFilePath).Equals(".xlsx"))
     {
       strConn = "provider=Microsoft.ACE.OLEDB.12.0;Data Source=''" + strFilePath + "'';Extended Properties=Excel 12.0;";
      }
      else
      {
         strConn = "provider=Microsoft.Jet.OLEDB.4.0;Data Source=''" + strFilePath + "'';Extended Properties=Excel 8.0;";
      }
      OleDbConnection cnCSV = new OleDbConnection(strConn);
      cnCSV.Open();
      System.Data.DataTable dtsheetName = new System.Data.DataTable();
      dtsheetName = cnCSV.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
      string excelSheets = string.Empty;
      int i = 0;
      foreach (DataRow row in dtsheetName.Rows)
      {
        excelSheets = row["TABLE_NAME"].ToString();
        break;
      }

      OleDbCommand cmdSelect = new OleDbCommand("SELECT * FROM [" + excelSheets + "]", cnCSV);
      OleDbDataAdapter daCSV = new OleDbDataAdapter();
      daCSV.SelectCommand = cmdSelect;
      dtCSV.Clear();   //dtCSV is a Global Variable of DataTable type
      daCSV.Fill(dtCSV);
      cnCSV.Close();
      daCSV.Dispose();
      cmdSelect.Dispose();
    }
    catch (Exception ex)
    {
     string Message = ex.Message.ToString();
     MessageBox.Show(Message);
    }
}

上传方法

Method for uploadation

private void Upload()
try
 {
  string fname = SelectTextFile();
  if (fname == null || string.IsNullOrEmpty(fname.Trim()))
  {
   MessageBox.Show("No Excel Sheet is selected to upload.");
  }
  else
  {
   string ifname = fname.Substring(fname.LastIndexOf(''\\'') + 1);
   string[] filename = ifname.Split(''.'');
   getDataFromXLS(fname);
   SqlBulkCopy bulk = new SqlBulkCopy(SQLConnection);
   bulk.DestinationTableName = "Test";
   bulk.WriteToServer(dtCSV);
   MessageBox.Show("Data uploaded successfully.");
  }
}
catch (Exception ex)
{
 MessageBox.Show(ex.Message.ToString());
}

您可以执行批量复制，例如 ^ ].

You can do this by doing a Bulk Copy as shown here[^].

/////////////////////////////////////////////////////////

//////////////////////////////////////////////////////////////////////

这篇关于关于接口集的简单问题\ 2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！