输入条件点击button后gridview显示查询结果

2024-12-30 21:34:23

推荐回答（1个）

回答1：

string sql = "select语句";
OleDbConnection conn = new OleDbConnection("@Provider=Microsoft.Jet.OLEDB.4.0;Data Source=数据库路径");
OleDbDataAdapter adapter = new OleDbDataAdapter(sql, conn);
DataSet ds = new DataSet();
adapter.Fill(ds);
conn.Close();
this.GridView1.DataSource = ds;
this.GridView1.DataBind();