Hi Aussie,

As Alexey has suggested, for SqlCommand object, after you initialize it,
you can call the "ExecuteReader" method (for select ) to return a
SqlDataReadere object. You can loop all the records in the resultset
through DataReader

#Retrieving Data Using a C# .NET DataReader
http://www.akadia.com/services/dotnet_data_reader.html

and for ASP.NET complex databound control, you can directly assign the
DataReader object to their "DataSource" property and call "DataBind" method
to perform databinding. e.g.

==============
SqlCommand comm;

.............

       SqlDataReader reader = comm.ExecuteReader();
       AdRotator1.DataSource = reader;
       AdRotator1.DataBind();
===================

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead



==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.



Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================



This posting is provided "AS IS" with no warranties, and confers no rights.

Hi,

Thanks for your reply.

I am still not able to get this to work. My code is as follows. When I view
source of the HTML page, there are no values for the adrotator at all.
The Stored Proc works fine.

I can't see whats wrong......

Try

   Dim SQLServerConnection As SqlConnection
   Dim SqlConnectionCls As New clsSQL
   SQLServerConnection = SqlConnectionCls.Connect
   Dim SqlCommand As New SqlCommand

With SqlCommand

   .CommandType = Data.CommandType.StoredProcedure
   .Connection = SQLServerConnection
   .CommandTimeout = 15
   .CommandText = "sproc_GetBannerAdvertDetails"

End With

' I have swapped these arround and tried, but not working. I have put the
image/navurl after the databind.

AdRotator1.ImageUrlField = "advert_image"
AdRotator1.NavigateUrlField = "advert_URLlink"
AdRotator1.DataSource = SqlCommand.ExecuteReader
AdRotator1.DataBind()

Catch ex As Exception

End Try