public class LoadMore
{
public bool InsertSQL(string path, string sheetName)
{
FileStream fs = new FileStream(path, FileMode.Open, FileAccess.Read, FileShare.Read);
DataTable dt = ReadExcel(sheetName, fs);
dt.Rows[0].Delete();
fs.Close();
OleDbCommand oleDBAccess = null;
OleDbConnection AccessCon = null;
string Connect = System.Configuration.ConfigurationManager.AppSettings["connectionString"] + System.Web.HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["data"]);
AccessCon = new OleDbConnection(Connect);
AccessCon.Open();
oleDBAccess = new OleDbCommand();
oleDBAccess.Connection = AccessCon;
oleDBAccess.Transaction = AccessCon.BeginTransaction();
try
{
for (int i = 0; i < dt.Rows.Count; i++)
{
//去掉第一行的说明
if (dt.Rows[i][0].ToString() == "")
{
continue;
}
else
{
string sqlstr = "insert into table values('" + dt.Rows[i][0].ToString() + "','" + dt.Rows[i][1].ToString() + "','&#