核心提示:string connStr = 'Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:DataBase Password=;Data Source=d:\\c#.n...
string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:DataBase Password=;Data Source=" + Server.MapPath(@"Data\数据库名.mdb");//相对路径
OleDbConnection conn = new OleDbConnection(connStr);
string sql = "select * from 数据表名 order by id desc";//定义执行查询操作的SQL语句
OleDbCommand cmd = new OleDbCommand(sql, conn);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataKeyNames = new string[] { "id" };
GridView1.DataBind(); //绑定数据库表中数据