SQL DataReader in IronPython

Question

Please help me to read just one record from MS SQL table.
I tried to do that in the next way (IronPython 2.6 RC1):

cmd = SqlCommand("SELECT * FROM myTable", cn)  
dr = cmd.ExecuteReader()

After that I have ALL the table in dr! But need only ONE record (more precise: read table records one by one)
...
Sorry!
I was wrong!
I forget about two more commands in my program:
table=[]
for row in dr: table.append(row)
So it turned out an equivalent to dr.Read()!...

Answer 1

Use TOP to restrict to one (random) record.

cmd = SqlCommand("SELECT TOP 1 * FROM myTable", cn)
dr=cmd.ExecuteReader()

Usually though when one is interested in a record, is interested in a specific record, like for example the one record with ID = 42.

TOP 1 will return the first record in the order the engine will choose to access the table.