ASP.NET and ADO.NET

[Marcin Tracz]

Hello!


I've got small problem with ADO.NET.

I have to use transaction on my page. I init connection with DB and
transaction by:


If Conn.State = ConnectionState.Broken Or Conn.State =
ConnectionState.Closed Then
Conn.Open()
End If
Dim ObjTrans As SqlTransaction
Dim command1 As SqlCommand = Conn.CreateCommand()
ObjTrans = Conn.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted)
command1.Connection = Conn
command1.Transaction = ObjTrans

But if I try run

sql2 = "SELECT * FROM TABLE"
command1.CommandText = sql2
dreader = command1.ExecuteReader()
id_drzewo = dreader.GetString(0)

I cannot get data from table. Why I cannot get data with SELECT if I'm
using transaction in ASP.NET. What can I do to get data?

Thanks for help!!

Marcin

 

[Steve C. Orr [MVP, MCSD]]

Try using a separate connection object for your select query.

 

[Marcin Tracz]

Try using a separate connection object for your select query.

I try but I also have the same problem. Any others Idea?
Thanks!

Marcin