By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,969 Members | 1,522 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,969 IT Pros & Developers. It's quick & easy.

Adrotator

P: n/a
Hi,
I have a adrotator control on a page, and want to program the connection of
the control via SQL.

I have the following code which doesn't seem to do much, and not sure what
else to do?
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_GetAddDetails"
End With

Me.AdRotator1.DataSource = SqlCommand

AdRotator1.ImageUrlField = "advert_image"
AdRotator1.NavigateUrlField = "advert_URLlink"


Jun 4 '07 #1
Share this Question
Share on Google+
7 Replies


P: n/a
On Jun 4, 9:31 pm, "Aussie Rules" <AussieRu...@nospam.nospamwrote:
Hi,
I have a adrotator control on a page, and want to program the connection of
the control via SQL.

I have the following code which doesn't seem to do much, and not sure what
else to do?

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_GetAddDetails"
End With

Me.AdRotator1.DataSource = SqlCommand

AdRotator1.ImageUrlField = "advert_image"
AdRotator1.NavigateUrlField = "advert_URLlink"
I think you forgot to get the data

AdRotator1.DataSource = SqlCommand.ExecuteReader

Jun 4 '07 #2

P: n/a
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/subscripti...ult.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/subscripti...t/default.aspx.

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

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

Jun 5 '07 #3

P: n/a
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


"Steven Cheng[MSFT]" <st*****@online.microsoft.comwrote in message
news:84**************@TK2MSFTNGHUB02.phx.gbl...
Hi Aussie,

Regarding on this issue, I have also seen your another one in the
following
newsgroup:

Subject: Adrotator
Newsgroups: microsoft.public.dotnet.framework.aspnet

Community member Alexey and I have posted some suggestion there. Please
have a look and feel free to followup in that thread if you have any
further questions.

Thanks for your posting!

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no
rights.
"Alexey Smirnov" <al************@gmail.comwrote in message
news:11*********************@i13g2000prf.googlegro ups.com...
On Jun 4, 9:31 pm, "Aussie Rules" <AussieRu...@nospam.nospamwrote:
>Hi,
I have a adrotator control on a page, and want to program the connection
of
the control via SQL.

I have the following code which doesn't seem to do much, and not sure
what
else to do?

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_GetAddDetails"
End With

Me.AdRotator1.DataSource = SqlCommand

AdRotator1.ImageUrlField = "advert_image"
AdRotator1.NavigateUrlField = "advert_URLlink"

I think you forgot to get the data

AdRotator1.DataSource = SqlCommand.ExecuteReader
Jun 5 '07 #4

P: n/a
On Jun 5, 7:26 pm, "Aussie Rules" <AussieRu...@nospam.nospamwrote:
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......
Aussie,

get rid of the try..catch block, I think you will see what is wrong.

Hope it helps

Jun 5 '07 #5

P: n/a
Hi,
Sorry I actually removed the catch code to save space. There was no error
created(catch never got fired)

Thanks

"Alexey Smirnov" <al************@gmail.comwrote in message
news:11*********************@p77g2000hsh.googlegro ups.com...
On Jun 5, 7:26 pm, "Aussie Rules" <AussieRu...@nospam.nospamwrote:
>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......

Aussie,

get rid of the try..catch block, I think you will see what is wrong.

Hope it helps
Jun 6 '07 #6

P: n/a
On Jun 6, 8:40 am, "Aussie Rules" <AussieRu...@nospam.nospamwrote:
Hi,
Sorry I actually removed the catch code to save space. There was no error
created(catch never got fired)

Thanks

"Alexey Smirnov" <alexey.smir...@gmail.comwrote in message

news:11*********************@p77g2000hsh.googlegro ups.com...
On Jun 5, 7:26 pm, "Aussie Rules" <AussieRu...@nospam.nospamwrote:
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......
Aussie,
get rid of the try..catch block, I think you will see what is wrong.
Hope it helps- Hide quoted text -

- Show quoted text -
Well, are you sure that sproc_GetBannerAdvertDetails is working? Try
to execute it in the Query Analizer (or any other tool to check the db
output)

Jun 6 '07 #7

P: n/a
Hi Aussie,

I'm not sure about your backend datasource. I suggest you perform the
following checK

1. Direclty bind the DataReader(get from SqlCommand) to a GridView (with
AutoGenerateColumns="true") to verify whether the reader has returned the
correctly & expected resultset

2. For databinding code logic, here is the code in my local test page for
your reference:
=================================
Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArgs) Handles Me.Load

BindRotator()

End Sub

Private Sub BindRotator()

Dim conn As SqlConnection
Dim comm As SqlCommand
Dim sql As String = "SELECT [id], [name], [description] FROM
[RVTable]"
Dim rdr As SqlDataReader
conn = New
SqlConnection(WebConfigurationManager.ConnectionSt rings("ASPNETTestDBConnect
ionString").ConnectionString)
conn.Open()
comm = New SqlCommand(sql, conn)

rdr = comm.ExecuteReader()

AdRotator1.DataSource = rdr
AdRotator1.ImageUrlField = "name"
AdRotator1.NavigateUrlField = "description"

AdRotator1.DataBind()

rdr.Close()

conn.Close()
End Sub
================================

If you have any further finding or question, please feel free to post here.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.

Jun 6 '07 #8

This discussion thread is closed

Replies have been disabled for this discussion.