try
{ string strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= class.mdb";
OleDbConnection myConn = new OleDbConnection(strCon);
myConn.Open();//连接数据库------------这里没有执行成功,不知道为什么 Label1.Text = "11111111111111111!"; string strcmd = "SELECT [UserName], [UserRealname], [UserTel] FROM [classmates] ORDER BY [Identi]";
Label1.Text = strcmd;
OleDbDataAdapter myCmmd = new OleDbDataAdapter(strcmd, myConn);
myCmmd.Fill(myDataset, "user"); //利用adapter对象把数据集塞到dataset中 Label1.Text = "连接成功!";
myConn.Close(); }
catch (Exception e1)
{
Console.WriteLine(e1.ToString());
Label1.Text = "连接出错!"; }
{ string strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= class.mdb";
OleDbConnection myConn = new OleDbConnection(strCon);
myConn.Open();//连接数据库------------这里没有执行成功,不知道为什么 Label1.Text = "11111111111111111!"; string strcmd = "SELECT [UserName], [UserRealname], [UserTel] FROM [classmates] ORDER BY [Identi]";
Label1.Text = strcmd;
OleDbDataAdapter myCmmd = new OleDbDataAdapter(strcmd, myConn);
myCmmd.Fill(myDataset, "user"); //利用adapter对象把数据集塞到dataset中 Label1.Text = "连接成功!";
myConn.Close(); }
catch (Exception e1)
{
Console.WriteLine(e1.ToString());
Label1.Text = "连接出错!"; }
{ string strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= class.mdb";
OleDbConnection myConn = new OleDbConnection(strCon);
myConn.Open();//连接数据库------------这里没有执行成功,不知道为什么 Label1.Text = "11111111111111111!"; string strcmd = "SELECT [UserName], [UserRealname], [UserTel] FROM [classmates] ORDER BY [Identi]";
Label1.Text = strcmd;
OleDbDataAdapter myCmmd = new OleDbDataAdapter(strcmd, myConn);
myCmmd.Fill(myDataset, "user"); //利用adapter对象把数据集塞到dataset中 Label1.Text = "连接成功!";
myConn.Close(); }
catch (Exception e1)
{
Console.WriteLine(e1.ToString());
Label1.Text = "连接出错!"; }
指定一下.mdb文件的绝对路径试一个
class.mdb 路径不对啊 你用绝对路径测试下 或者把数据库放到App_Data下面
运行结果还是:连接出错
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath("~/App_Data/class.mdb");