http://heisetoufa.javaeye.com/blog/245953
DataSet ds;
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
ds = ImportExcel(this.openFileDialog1.FileName);//获得Excel
}
else
{
return;
} 上面那段代码出自顶上那个网址我把它偷来改成我这样 DataSet ds;
string fileName = "";
OpenFileDialog openFile = new OpenFileDialog();
openFile.Multiselect = false;
openFile.RestoreDirectory = true;
openFile.Filter = "Text files (*.xls)|*.xls|All files (*.*)|*.*";
if (openFile.ShowDialog() == DialogResult.OK)
{
textBox1.Text = openFile.FileName;
fileName = openFile.FileName;
ds = ImportExcel(this.openFile.FileName);//获得Excel
}重新生成的时候报错,
当前上下文中不存在名称"ImportExcel"
"WindowsApplication1.Form1"并不包含openFile的定义
请教各位大虾, 我该怎么改正??
请各位大虾看下那网址``
放心 不是毒```谢谢各位了```
DataSet ds;
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
ds = ImportExcel(this.openFileDialog1.FileName);//获得Excel
}
else
{
return;
} 上面那段代码出自顶上那个网址我把它偷来改成我这样 DataSet ds;
string fileName = "";
OpenFileDialog openFile = new OpenFileDialog();
openFile.Multiselect = false;
openFile.RestoreDirectory = true;
openFile.Filter = "Text files (*.xls)|*.xls|All files (*.*)|*.*";
if (openFile.ShowDialog() == DialogResult.OK)
{
textBox1.Text = openFile.FileName;
fileName = openFile.FileName;
ds = ImportExcel(this.openFile.FileName);//获得Excel
}重新生成的时候报错,
当前上下文中不存在名称"ImportExcel"
"WindowsApplication1.Form1"并不包含openFile的定义
请教各位大虾, 我该怎么改正??
请各位大虾看下那网址``
放心 不是毒```谢谢各位了```
你没有定义ImportExcel函数,你把那个网址里定义这个函数拷贝过来吧;2."WindowsApplication1.Form1"并不包含openFile的定义
把ds = ImportExcel(this.openFile.FileName);里面的this.去掉
即改成ds = ImportExcel(openFile.FileName);//获得Excel
你把this去掉而且ImportExcel(this.openFile.FileName);方法应该是自己写的方法不没定义当然报错了
{
DataSet ds = null;
using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";Extended Properties=Excel 9.0;"))
{
conn.Open(); DataTable schemaTable = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null); string tableName = schemaTable.Rows[0][2].ToString();
string strSql = "Select * From [" + tableName + "]";
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(strSql, conn); dataAdapter.Fill(ds, tableName); conn.Close();
} return ds;
}