本文介绍了关于接口集的简单问题\ 2的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
应用解决方案如下//////////////////////////////////////////////
the app soluion is as follows//////////////////////////////////////////////
推荐答案
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());
}
这篇关于关于接口集的简单问题\ 2的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!