62,046
社区成员
发帖
与我相关
我的任务
分享
string ConStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("Ex07_01.mdb") + ";Connect Timeout=60;";
OleDbConnection oc = new OleDbConnection(ConStr);
Response.Write(ConStr + "<br>");
try
{
//打开数据库连接
string sqlstr = "select * from tb_info";
oc.Open();
OleDbCommand comm = new OleDbCommand();
comm.Connection = oc;
comm.CommandText = sqlstr;
comm.CommandType = CommandType.Text;
comm.CommandTimeout = 88;
OleDbDataAdapter oa = new OleDbDataAdapter();
oa.SelectCommand = comm;
DataSet ds = new DataSet();
oa.Fill(ds, "tb_info");
GridView1.DataSource = ds;
GridView1.DataBind();
Response.Write("<script language=javascript>alert('连接Access数据库成功!')</script>");
}
catch (Exception ex)
{
Response.Write("<script language=javascript>alert('" + ex.Message + "')</script>");
}
finally
{
//关闭数据库连接
oc.Close();
}