Multiple SqlDataSource in a page

Hi,

I placed several SqlDataSource objects on my page which work with the same
database (same connection string).

As I know, connection operation to database is costly in the performance
prespective.

Do these SqlDataSource controls work with the same connection object or each
of them create his own connecton object?

If each create it's own, then can they be changed to work with one
connection object?



Thanks
Goldwind [ So, 26 November 2006 16:19 ] [ ID #1547842 ]

Re: Multiple SqlDataSource in a page

"Goldwind" <Goldwind [at] discussions.microsoft.com> wrote in message
news:CA39130A-1DCB-4D04-BD2F-FEAEEB0BB8B1 [at] microsoft.com...
> Hi,
>
> I placed several SqlDataSource objects on my page which work with the same
> database (same connection string).
>
> As I know, connection operation to database is costly in the performance
> prespective.
>
> Do these SqlDataSource controls work with the same connection object or
> each
> of them create his own connecton object?
>
> If each create it's own, then can they be changed to work with one
> connection object?
>

This is a classic asp group. Dotnet questions should be asked in
microsoft.public.dotnet.framework.aspnet.

--
Mike Brind
Mike Brind [ So, 26 November 2006 19:30 ] [ ID #1547843 ]
Webserver » microsoft.public.inetserver.asp.db » Multiple SqlDataSource in a page

Vorheriges Thema: Searching Multiple Tables
Nächstes Thema: Webapplication with SQL Server for more companies