Csharp sql server query locks database as I step through it

[Steve]

Is there a way in cSharp using SqlDataReader, SqlConnection and sqlCommand, to step through a query and not lock it, like the option adOpenStatic in vb6 did? Thanks

[Subin Ninan]

Set MultipleActiveR esultSets property to True in connection string.

[Steve]

Hi thanks for the reply but that did not work. While a report was running, a application could not connect to the database. I got around this my using a DataSet in my report.