//定义
String strConn, strSql;
OleDbConnection myConn;
OleDbCommand myComm;
//连接数据库
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("App_Data/test.mdb");
myConn = new OleDbConnection(strConn);
myConn.Open();
//显示数据
strSql = "select * from students order by ID asc";//sql语句
myComm = new OleDbCommand(strSql, myConn);
OleDbDataReader rs = myComm.ExecuteReader();
List<StuModels> list = new List<StuModels>();
StuModels usermodel;
while (rs.Read())
{
usermodel = new StuModels();
usermodel.id = Convert.ToInt32(rs["id"]);
usermodel.Name = rs["Name"].ToString();
usermodel.tel = rs["tel"].ToString();
list.Add(usermodel);
}
ViewData["list"] = list;
return View("Students");
String strConn, strSql;
OleDbConnection myConn;
OleDbCommand myComm;
//连接数据库
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("App_Data/test.mdb");
myConn = new OleDbConnection(strConn);
myConn.Open();
//显示数据
strSql = "select * from students order by ID asc";//sql语句
myComm = new OleDbCommand(strSql, myConn);
OleDbDataReader rs = myComm.ExecuteReader();
List<StuModels> list = new List<StuModels>();
StuModels usermodel;
while (rs.Read())
{
usermodel = new StuModels();
usermodel.id = Convert.ToInt32(rs["id"]);
usermodel.Name = rs["Name"].ToString();
usermodel.tel = rs["tel"].ToString();
list.Add(usermodel);
}
ViewData["list"] = list;
return View("Students");