«

Hi,

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

Thanks,

Tintin92

On Jun 24, 12:32 pm, "Pierre" <n...@spam.com> wrote:
> 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.

"Pierre" wrote:
>> How to copy the result from a Select into a DataSet ?

wrote:
> 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"?

--
Lew