求大神帮忙啊
if (dlg.ShowDialog() == DialogResult.OK) 第一次打开导入数据库没问题 第二次再点浏览的时候报错“尝试读取或写入受保护的内存。这通常指示其他内存已损坏”
代码:
private void butdr_Click(object sender, EventArgs e)
{
OpenFileDialog dlg = new OpenFileDialog();
dlg.Filter = "Excel文件(*.xls)|*.xls";
dlg.RestoreDirectory = true;
if (dlg.ShowDialog() == DialogResult.OK)
{
string filePath = dlg.FileName;
this.textBox1.Text = filePath;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Length == 0)
{
MessageBox.Show("请选择导入数据的Execl文件");
}
else
{
try
{
OleDbConnectionStringBuilder connectStringBuilder = new OleDbConnectionStringBuilder();
connectStringBuilder.DataSource = this.textBox1.Text.Trim();
connectStringBuilder.Provider = "Microsoft.Jet.OLEDB.4.0";
connectStringBuilder.Add("Extended Properties", "Excel 8.0");
using (OleDbConnection cn = new OleDbConnection(connectStringBuilder.ConnectionString))
{
DataSet ds = new DataSet();
string sql = "Select * from [农户信息表$]";
OleDbCommand cmdLiming = new OleDbCommand(sql, cn);
cn.Open();
using (OleDbDataReader drLiming = cmdLiming.ExecuteReader())
{
ds.Load(drLiming, LoadOption.OverwriteChanges, new string[] { "Sheet1" });
DataTable dt = ds.Tables["Sheet1"];
if (dt.Rows.Count > 0)
{
//dataGridView1.DataSource = dt;
for (int i = 0; i < dt.Rows.Count; i++)
{
//写入数据库数据
string Mysql = "insert into users ([number],[name],sfzh,hkbh,yhzh,khyh,skhhh,tel,address,Remark) values('" + dt.Rows[i]["农户编号"].ToString() + "','" + dt.Rows[i]["户主姓名"].ToString() + "','" + dt.Rows[i]["身份证号"].ToString() + "','" + dt.Rows[i]["户口本号"].ToString() + "','" + dt.Rows[i]["银行账号"].ToString() + "','" + dt.Rows[i]["开户银行"].ToString() + "'" +
",'" + dt.Rows[i]["收款行行号"].ToString() + "','" + dt.Rows[i]["联系电话_(或村委会电话)"].ToString() + "','" + dt.Rows[i]["家庭住址"].ToString() + "','')";
WebBase.Data.AcDb.Exec(Mysql);
}
MessageBox.Show("数据导入成功!");
}
else
{
MessageBox.Show("请检查你的Excel中是否存在数据");
}
drLiming.Close();
}
cn.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
帮我看看那的错啊