Re: [Firebird-net-provider] Select statements and transactions

[<car...@te...>]

Hello:

>       After I have done a select statement through the .net provider do I
> have to commit it? and if so what is the procedure.

Which version of the .NET Data Provider are you using ?? Are you using 
connection pooling ?? (it's enabled by default)

> The code I am running to populate my drop dowm box is

Try this:

Dim strSQL As String = "select  ID, DISPLAY_TEXT from EE_SP_NAME
  	ORDER BY DISPLAY_TEXT"
Dim objConn As FirebirdSql.Data.Firebird.FbConnection = New
  	FirebirdSql.Data.Firebird.FbConnection
Dim objCMD As FirebirdSql.Data.Firebird.FbCommand = New
	FirebirdSql.Data.Firebird.FbCommand
Dim objTran As FirebirdSql.Data.Firebird.FbTransaction
Dim objReader As FirebirdSql.Data.Firebird.FbDataReader
objConn.ConnectionString =
	ConfigurationSettings.AppSettings("DbConnectionString")
objCMD.CommandText = strSQL
objCMD.CommandType = CommandType.Text
objConn.Open()
objCMD.Connection = objConn
objReader = objCMD.ExecuteReader()
CmbTargetGroup.DataSource = objReader
CmbTargetGroup.DataValueField = "ID"
CmbTargetGroup.DataTextField = "DISPLAY_TEXT"
CmbTargetGroup.DataBind()
objReader.Close()
objCMD.Dispose()
objConn.Close()




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain