Re: DataReader Behavior

[Oscar Rodríguez]

Thank Simon

About of the question 1, are you refering are MySQLCommand?.
Check my code:

sql = "select * from table1"
cnn1.Open()
cmd = New MySqlCommand(sql, cnn1)
dr = cmd.ExecuteReader

Do While dr.Read
sql = "select * from table2 where field1 = " & dr("fieldn")
cnn2.Open()
cmd = New MySqlCommand(sql, cnn2)
dr2 = cmd.ExecuteReader

If Not dr2.Read Then
sql = "delete from table1 where field1 = " & dr2("field1")
cnn3.Open()
cmd = New MySqlCommand(sql, cnn3)
cmd.ExecuteNonQuery()
cnn3.Close()
End If

cnn2.Close()
Loop

cnn1.Close
------------------------------------

This code is wrong?

Cheers my bro!!! or like say in Panamá(my country): Chillin mi fren