读取Access数据库中的数据

 

public void InitGrid()
    {
        string connectstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Exam.mdb";
        OleDbConnection conn = new OleDbConnection(connectstring);
        string sqlQuery="select * from tb_Exam";
        OleDbDataAdapter a = new OleDbDataAdapter(sqlQuery, conn);
        //OleDbCommand com = new OleDbCommand(sqlQuery, conn);
        DataSet ds = new DataSet();
        a.Fill(ds,"yo");
        this.GridView1.DataSource = ds.Tables["yo"];
        this.GridView1.DataBind();
    }

    public void InitGridEx(string b)
    {
        string connectstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Exam.mdb";
        OleDbConnection conn = new OleDbConnection(connectstring);
        conn.Open();
        string sqlQuery = "select * from tb_Exam where ID=" + b;
        //OleDbDataAdapter a = new OleDbDataAdapter(sqlQuery, conn);
        OleDbCommand com = new OleDbCommand(sqlQuery, conn);
        //DataSet ds = new DataSet();
        //a.Fill(ds, "yo");
        OleDbDataReader da = com.ExecuteReader();
        //this.GridView1.DataSource = ds.Tables["yo"];
        //this.GridView1.DataBind();
        while(da.Read())
        {
            this.TextBox2.Text=da["ID"].ToString();
            this.TextBox3.Text = da["ExamContent"].ToString();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string a = this.TextBox1.Text;
        InitGridEx(a);
    }