I m making rowset by first making statement and Resultset through sql.
Connection cn = .................
Statement st = cn.createStatement();
ResultSet rs = st.executeQuery("Select pr_id,pr_name from Product");
CachedRowSet crs = new CachedRowSet();
crs.populate(rs);
thats how I do it.
How can I search any pr_id(Product ID) in the rowset.