dataGridView1.AutoGenerateColumns = false; OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=c:\\txl.mdb"); con.Open(); string sql = "select * from stuff where id = "+TextBox1.Text;//如果是字符型字段,还要加引号 OleDbDataAdapter da = new OleDbDataAdapter(sql, con); DataSet ds = new DataSet(); da.Fill(ds, "stuff");//填充到ds //剩下的想访问什么就通过 ds.Tables["stuff"].Rows[0]["列名"]访问
dataGridView1.AutoGenerateColumns = false;
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=c:\\txl.mdb");
con.Open();
string sql = "select * from stuff where id = "+TextBox1.Text;//如果是字符型字段,还要加引号
OleDbDataAdapter da = new OleDbDataAdapter(sql, con);
DataSet ds = new DataSet();
da.Fill(ds, "stuff");//填充到ds
//剩下的想访问什么就通过 ds.Tables["stuff"].Rows[0]["列名"]访问
dataGridView1.AutoGenerateColumns = false;
da.Fill(ds, "stuff"); 这句报错,说语法错误