using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;namespace shenkesoftware
{
public partial class test : Form
{
private OleDbConnection conn = null;
public test()
{
InitializeComponent();
this.conn = new OleDbConnection(shenkesoftware.database.dbConnection.connection);
} private void btQuery_Click(object sender, EventArgs e)
{
OpenFileDialog dlg = new OpenFileDialog();
dlg.Filter = "Excel文件(*.xls)|*.xls";
if (dlg.ShowDialog() == DialogResult.OK)
{
string filePath = dlg.FileName;
conn.Open();//这里出现问题了,我是把数据库文件放在debug目录下的,打开桌面文件,然后就提示路径出错。
} }
}
}数据库链接代码:
using System;
namespace shenkesoftware.database
{
/// <summary>
/// dbConnection 的摘要说明。
/// </summary>
public class dbConnection
{
public dbConnection()
{
//
// TODO: 在此处添加构造函数逻辑
//
} public static string connection
{
get
{ return "Data Source=peopledb.mdb;Provider=Microsoft.Jet.OLEDB.4.0;"; }
}
}
}
2:连接字符串有问题,
最好把出错信息报到出来
2:连接字符串有问题
最好把错误信息报出来