How to copy the result from a Select into a DataSet ?

[Pierre]

Hi,

How to copy the result from a Select into a DataSet ?

Thanks,

Tintin92

 

[bencoe]

Hi,

How to copy the result from a Select into a DataSet ?

Thanks,

Tintin92

An SQL select statement? SELECT x FROM x WHERE X AND Y?


Ben.

 

[Lew]

An SQL select statement? SELECT x FROM x WHERE X AND Y?

Assuming SQL via JDBC:

<http://java.sun.com/javase/6/docs/api/java/sql/ResultSet.html>
obtained from, say, a
<http://java.sun.com/javase/6/docs/api/java/sql/PreparedStatement.html>

PreparedStatement pstmt = con.prepareStatement(
"SELECT name, salary WHERE id = ?" );
ps.setString( 1, "1719232931" );
ResultSet rs = ps.executeQuery();
String name = rs.getString( "name" );
BigDecimal salary = getBigDecimal( "salary" );

Assuming anything other than what we've guessed, you'll have to be a lot more
specific. What kind of "Select"? What is a "DataSet"?