string constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Server.MapPath("~/App_Data/AskToDoctor.mdb");
OleDbConnection conn = new OleDbConnection(constr);
conn.Open(); string sql = "Select top 1 * from Question";
OleDbDataAdapter ada = new OleDbDataAdapter(sql, conn);
DataSet ds = new DataSet();
ada.Fill(ds, "Question");
//以上数据库已连接成功数据库为Question
需读取的字段为QTitle
注:asp.net(C#)
OleDbConnection conn = new OleDbConnection(constr);
conn.Open(); string sql = "Select top 1 * from Question";
OleDbDataAdapter ada = new OleDbDataAdapter(sql, conn);
DataSet ds = new DataSet();
ada.Fill(ds, "Question");
//以上数据库已连接成功数据库为Question
需读取的字段为QTitle
注:asp.net(C#)
if(dt.Rows.Count >0)
{
this.Label1.Text = dt.Rows[0]["QTittle"].ToString();
}