满意答案
o8wlfkcnr
推荐于 .01.01
采纳率:45%等级:7
已帮助:311人
用下面这个方法把excel导入dataview,再把它导入database就简单了
public DataSet ReadExcel_ds(string FilePath)
{
string subfile = FilePath.Substring(FilePath.LastIndexOf(".") + 1);
DataSet ds = new DataSet();
string strCon = "";
if (subfile.ToUpper() == "XLS")
{
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;data source=" + FilePath;
}
if (subfile.ToUpper() == "XLSX")//excel读取
{
strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath + ";Extended Properties=\"Excel 12.0;HDR=YES\"";
}
System.Data.OleDb.OleDbConnection Conn = new System.Data.OleDb.OleDbConnection(strCon);
try
{
Conn.Open();
System.Data.DataTable sTable = Conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);//新添加 -10-14
string tableName = sTable.Rows[0][2].ToString().Trim();//新添加 -10-14 获取工作表名称
string strCom = "SELECT * FROM [" + tableName + "] ";
System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strCom, Conn);
myCommand.Fill(ds, "[" + tableName + "]");
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
finally
{
Conn.Close();
}
return ds;
}
00分享举报
dataset中的数据批量导入oracle数据库 C#如何把某个文件夹下的所有Excel文件导入Oracle数据库。详细点!...