佚名通过本文主要向大家介绍了c#winform,c#winform窗体美化,c#winform教程,c#winform视频教程,c#winform开发框架等相关知识,希望对您有所帮助,也希望大家支持linkedu.com www.linkedu.com
问题： C#winform中Microsoft Jet 数据库引擎找不到对象'xy-zy2012‘
描述:
string[] dbfile = Directory.GetFiles(Environment.CurrentDirectory, "xy-zy" + DateTime.Now.Year.ToString() + ".xls");
string connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + dbfile[0] + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'";
OleDbConnection OleDbconn = new OleDbConnection(connStr);
OleDbconn.Open();
string sql = "select * from [xy-zy" + DateTime.Now.Year.ToString() + "$]";
OleDbDataAdapter OleDbda = new OleDbDataAdapter(sql, OleDbconn);
System.Data.DataTable dt = new System.Data.DataTable();
OleDbda.Fill(dt);
OleDbda.Dispose();
OleDbconn.Close();
程序报错Microsoft Jet 数据库引擎找不到对象'xy-zy2012’
急求大神指导
描述:
C#
源程序如下：string[] dbfile = Directory.GetFiles(Environment.CurrentDirectory, "xy-zy" + DateTime.Now.Year.ToString() + ".xls");
string connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + dbfile[0] + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'";
OleDbConnection OleDbconn = new OleDbConnection(connStr);
OleDbconn.Open();
string sql = "select * from [xy-zy" + DateTime.Now.Year.ToString() + "$]";
OleDbDataAdapter OleDbda = new OleDbDataAdapter(sql, OleDbconn);
System.Data.DataTable dt = new System.Data.DataTable();
OleDbda.Fill(dt);
OleDbda.Dispose();
OleDbconn.Close();
程序报错Microsoft Jet 数据库引擎找不到对象'xy-zy2012’
急求大神指导