欢迎各位下载我写的一个Excel与数据库互导数据的小程序 http://download.youkuaiyun.com/detail/lxp520llq/4507689
class ExceltoDatabase
{
public static string FillData(string openFilePath, string ID, string pwd, string dataBase, string tableName, string dataBaseType)
{
DataTable dt = ExcelToDt(openFilePath);
if (dataBaseType=="Oracle")
{
using (OracleConnection conn = new OracleConnection("Data Source=" + dataBase + ";uid=" + ID + ";pwd=" + pwd + ";"))
{
conn.Open();
for (int i = 1; i < dt.Columns.Count; i++)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
string cmd = "insert into " + tableName + " (" + dt.C