ACCESS数据库连接ASP.NET(C#)

最新推荐文章于 2024-10-17 18:58:27 发布

haoyuzhou009

最新推荐文章于 2024-10-17 18:58:27 发布

阅读量554

点赞数

文章标签： asp.net access 数据库 c# string qq

本文链接：https://blog.csdn.net/haoyuzhou009/article/details/2172872

版权

   string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
   strConnection+=@"Data Source=D:/9527.mdb";
   OleDbConnection objConnection=new OleDbConnection(strConnection);
   string sql = "select * from test";
   OleDbCommand objCommand = new OleDbCommand(sql , objConnection);
   objConnection.Open();
   OleDbDataReader objDataReader=objCommand.ExecuteReader();
   string qq="";
   while(objDataReader.Read())
   {
    string ss =Convert.ToString(objDataReader["id"]);
    string cc =Convert.ToString(objDataReader["code"]);
    string vv =Convert.ToString(objDataReader["main"]);
    string mm =Convert.ToString(objDataReader["as"]);
     qq = "<tr><td>"+ss+"</td><td>"+cc+"</td><td>"+vv+"</td><td>"+mm+"</td></tr>";
    Response.Write("<table>"+qq+"</table>");
   }