这样写也行 OleDbConnection con = new OleDbConnection(connString); OleDbDataAdapter da = new OleDbDataAdapter(); da.SelectCommand = new OleDbCommand("SELECT * FROM Customers WHERE CustomerID="+CustomerIDvalue,con); DataSet ds = new DataSet(); da.Fill(ds);如果CustomerID定义为是varchar型的话(没人会这么定义) 下面这句改为 da.SelectCommand = new OleDbCommand("SELECT * FROM Customers WHERE CustomerID='"+CustomerIDvalue="'",con);
oleCmd.CommandText="SELECT * FROM Customers WHERE CustomerID =@CustomerIDvalue";
oleCmd.Parameter.Add(new Parameter("@CustomerIDvalue",CustomerIDvalue));
然后执行oleCmd用DataReader或DataSet接收记录
com.Parameters.Add("?",类型).Value = "XXX";
OleDbConnection con = new OleDbConnection(connString);
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = new OleDbCommand("SELECT * FROM Customers WHERE CustomerID="+CustomerIDvalue,con);
DataSet ds = new DataSet();
da.Fill(ds);如果CustomerID定义为是varchar型的话(没人会这么定义) 下面这句改为
da.SelectCommand = new OleDbCommand("SELECT * FROM Customers WHERE CustomerID='"+CustomerIDvalue="'",con);