if (textBox1.Text.Trim() == "")
{
MessageBox.Show("请填写路径!");
return;
}
OleDbConnection conn = new OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\ljdata.mdb");
OleDbConnection conn_Excel = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;Extended properties=Excel 5.0;Data Source=" + textBox1.Text);
OleDbTransaction tran = null;
try
{
//查出EXCEL放入DataTable conn_Excel.Open();
string sql = "select * from [Sheet1$]";
DataTable dt = new DataTable();
OleDbDataAdapter sda = new OleDbDataAdapter(sql,conn_Excel);
sda.Fill(dt); if (dt == null)
{
MessageBox.Show("您导入的文档名字有误!请去掉空格或特殊字符!");
return;
} //去掉空行
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][0].ToString().Trim() == string.Empty)
{
dt.Rows.Remove(dt.Rows[i--]);
}
}
//开始事务
tran = conn.BeginTransaction();
OleDbCommand cmd = conn.CreateCommand();
cmd.Transaction = tran;
for (int i = 0; i < dt.Rows.Count; i++)
{
// string sql_insert = "insert into student(id,name,sex,year,moon,day,class,minzu,shenfenzheng) values ('dt.Rows[i][0].ToString()','dt.Rows[i][1].ToString()','dt.Rows[i][2].ToString()','dt.Rows[i][3].ToString()','dt.Rows[i][4].ToString()','dt.Rows[i][5].ToString()','dt.Rows[i][6].ToString()','dt.Rows[i][7].ToString()','dt.Rows[i][8].ToString()')";
string sql_insert = string.Format("insert into student (id,name,sex,year,moon,day,class,minzu,shenfenzheng) values ('1','1','1','1','1','1','1','1','1')");
cmd.CommandText = sql_insert;
cmd.ExecuteNonQuery();
}
tran.Commit();//提交事务
MessageBox.Show("导入成功!");
}
catch
{
MessageBox.Show("导入失败!");
tran.Rollback();
}
finally
{
conn.Dispose();
conn_Excel.Dispose();
} }
}
执行上述语句提示导入失败。没有执行insert语句 好像是执行到红色的语句出的问题。请高手指点一二。非常感谢.
{
MessageBox.Show("请填写路径!");
return;
}
OleDbConnection conn = new OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\ljdata.mdb");
OleDbConnection conn_Excel = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;Extended properties=Excel 5.0;Data Source=" + textBox1.Text);
OleDbTransaction tran = null;
try
{
//查出EXCEL放入DataTable conn_Excel.Open();
string sql = "select * from [Sheet1$]";
DataTable dt = new DataTable();
OleDbDataAdapter sda = new OleDbDataAdapter(sql,conn_Excel);
sda.Fill(dt); if (dt == null)
{
MessageBox.Show("您导入的文档名字有误!请去掉空格或特殊字符!");
return;
} //去掉空行
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][0].ToString().Trim() == string.Empty)
{
dt.Rows.Remove(dt.Rows[i--]);
}
}
//开始事务
tran = conn.BeginTransaction();
OleDbCommand cmd = conn.CreateCommand();
cmd.Transaction = tran;
for (int i = 0; i < dt.Rows.Count; i++)
{
// string sql_insert = "insert into student(id,name,sex,year,moon,day,class,minzu,shenfenzheng) values ('dt.Rows[i][0].ToString()','dt.Rows[i][1].ToString()','dt.Rows[i][2].ToString()','dt.Rows[i][3].ToString()','dt.Rows[i][4].ToString()','dt.Rows[i][5].ToString()','dt.Rows[i][6].ToString()','dt.Rows[i][7].ToString()','dt.Rows[i][8].ToString()')";
string sql_insert = string.Format("insert into student (id,name,sex,year,moon,day,class,minzu,shenfenzheng) values ('1','1','1','1','1','1','1','1','1')");
cmd.CommandText = sql_insert;
cmd.ExecuteNonQuery();
}
tran.Commit();//提交事务
MessageBox.Show("导入成功!");
}
catch
{
MessageBox.Show("导入失败!");
tran.Rollback();
}
finally
{
conn.Dispose();
conn_Excel.Dispose();
} }
}
执行上述语句提示导入失败。没有执行insert语句 好像是执行到红色的语句出的问题。请高手指点一二。非常感谢.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货