Will two SQLDataAdapters.Fill() on one SQLConnection work?

[DotNetter]

Can you have the Fill() function of two different SQLDataAdapters objects executing simultaneously using the same one SQLConnection?

Thanks,
Dot

 

[jbenson001]

I don't think they will Fill simultaneously, but you can have one connections object assigned to multiple sqldataadapters.

 

[DotNetter]

I understand the Fill won't happen simultaneously... but if the Fill() of SQLDataAdapter "A" is called while SQLDataAdapter "B" is actively "filling" - and they share the same SQLConnection - will one SQLDataAdapter "step on the toes" of the other?

Thanks!
Dot

 

[jbenson001]

I belive "A" will finish before "B" will start. The easiest way is to test it in your page. But I am pretty sure "A" will finish, then "B" will start.

 

[DotNetter]

Thanks, J!

Does anyone know if this is documented anywhere "officially"?

Thanks!
Dot

 

[DotNetter]

I tried this:

Imports System.Data.SqlClient


Public Class MultipleDataAdaptersOnOneConnection
	Dim conn As New SqlConnection

	Dim da1 As New SqlDataAdapter
	Dim cmd1 As New SqlCommand
	Dim ds1 As New DataSet

	Dim da2 As New SqlDataAdapter
	Dim cmd2 As New SqlCommand
	Dim ds2 As New DataSet

''''''''''''''''''''''''''''''''

	Public Sub TwoDataAdaptersOnOneConnection()

		conn.ConnectionString = "database=UserAccounts;server=Batch;Integrated Security=SSPI"
		conn.Open()
		Dim oThread1 As New System.Threading.Thread(AddressOf Fill1)
		oThread1.Start()

		Dim oThread2 As New System.Threading.Thread(AddressOf Fill2)
		oThread2.Start()

	End Sub

''''''''''''''''''''''''''''''''

	Private Sub Fill1()

		Try
			da1.SelectCommand = cmd1
			da1.SelectCommand.Connection = conn
			da1.SelectCommand = cmd1
			cmd1.CommandType = CommandType.StoredProcedure
			cmd1.CommandText = "dbo.spud_BadQueryLONG"
			Debug.WriteLine("1 starting")
			da1.Fill(ds1)
			Debug.WriteLine("1 ending")
		Catch ex As Exception
			Dim a As String = ""
		End Try

	End Sub

''''''''''''''''''''''''''''''''

	Private Sub Fill2()
		Try
			da2.SelectCommand = cmd2
			da2.SelectCommand.Connection = conn
			da2.SelectCommand = cmd2
			cmd2.CommandType = CommandType.StoredProcedure
			cmd2.CommandText = "dbo.spud_BadQuerySHORT"
			Debug.WriteLine("2 starting")
			da2.Fill(ds2)
			Debug.WriteLine("2 ending")
		Catch ex As Exception
			Dim a As String = ""
		End Try

	End Sub

End Class

which output this in the Output Window:[tt]
2 starting
1 starting
The thread '<No Name>' (0x78) has exited with code 0 (0x0).
The thread '<No Name>' (0xb94) has exited with code 0 (0x0).[/tt]

...???
Dot