Adrotator

[Aussie Rules]

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 SQLServerConnec tion As SqlConnection
Dim SqlConnectionCl s As New clsSQL
SQLServerConnec tion = SqlConnectionCl s.Connect

Dim SqlCommand As New SqlCommand

With SqlCommand
.CommandType = Data.CommandTyp e.StoredProcedu re
.Connection = SQLServerConnec tion
.CommandTimeout = 15
.CommandText = "sproc_GetAddDe tails"
End With

Me.AdRotator1.D ataSource = SqlCommand

AdRotator1.Imag eUrlField = "advert_ima ge"
AdRotator1.Navi gateUrlField = "advert_URLlink "

[Alexey Smirnov]

On Jun 4, 9:31 pm, "Aussie Rules" <AussieRu...@no spam.nospamwrot e:

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 SQLServerConnec tion As SqlConnection
Dim SqlConnectionCl s As New clsSQL
SQLServerConnec tion = SqlConnectionCl s.Connect

Dim SqlCommand As New SqlCommand

With SqlCommand
.CommandType = Data.CommandTyp e.StoredProcedu re
.Connection = SQLServerConnec tion
.CommandTimeout = 15
.CommandText = "sproc_GetAddDe tails"
End With

Me.AdRotator1.D ataSource = SqlCommand

AdRotator1.Imag eUrlField = "advert_ima ge"
AdRotator1.Navi gateUrlField = "advert_URLlink "

I think you forgot to get the data

AdRotator1.Data Source = SqlCommand.Exec uteReader

[Steven Cheng[MSFT]]

Hi Aussie,

As Alexey has suggested, for SqlCommand object, after you initialize it,
you can call the "ExecuteRea der" 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.ExecuteRea der();
AdRotator1.Data Source = reader;
AdRotator1.Data Bind();
=============== ====

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.

[Aussie Rules]

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 SQLServerConnec tion As SqlConnection
Dim SqlConnectionCl s As New clsSQL
SQLServerConnec tion = SqlConnectionCl s.Connect
Dim SqlCommand As New SqlCommand

With SqlCommand

.CommandType = Data.CommandTyp e.StoredProcedu re
.Connection = SQLServerConnec tion
.CommandTimeout = 15
.CommandText = "sproc_GetBanne rAdvertDetails"

End With

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

AdRotator1.Imag eUrlField = "advert_ima ge"
AdRotator1.Navi gateUrlField = "advert_URLlink "
AdRotator1.Data Source = SqlCommand.Exec uteReader
AdRotator1.Data Bind()

Catch ex As Exception
End Try


"Steven Cheng[MSFT]" <st*****@online .microsoft.comw rote in message
news:84******** ******@TK2MSFTN GHUB02.phx.gbl. ..

Hi Aussie,

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

Subject: Adrotator
Newsgroups: microsoft.publi c.dotnet.framew ork.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******** *************@i 13g2000prf.goog legroups.com...

On Jun 4, 9:31 pm, "Aussie Rules" <AussieRu...@no spam.nospamwrot e:

>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 SQLServerConnec tion As SqlConnection
Dim SqlConnectionCl s As New clsSQL
SQLServerConnec tion = SqlConnectionCl s.Connect

Dim SqlCommand As New SqlCommand

With SqlCommand
.CommandType = Data.CommandTyp e.StoredProcedu re
.Connection = SQLServerConnec tion
.CommandTimeout = 15
.CommandText = "sproc_GetAddDe tails"
End With

Me.AdRotator1.D ataSource = SqlCommand

AdRotator1.Imag eUrlField = "advert_ima ge"
AdRotator1.Navi gateUrlField = "advert_URLlink "

I think you forgot to get the data

AdRotator1.Data Source = SqlCommand.Exec uteReader

[Alexey Smirnov]

On Jun 5, 7:26 pm, "Aussie Rules" <AussieRu...@no spam.nospamwrot e:

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

[Aussie Rules]

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******** *************@p 77g2000hsh.goog legroups.com...

On Jun 5, 7:26 pm, "Aussie Rules" <AussieRu...@no spam.nospamwrot e:

>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

[Alexey Smirnov]

On Jun 6, 8:40 am, "Aussie Rules" <AussieRu...@no spam.nospamwrot e:

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******** *************@p 77g2000hsh.goog legroups.com...

On Jun 5, 7:26 pm, "Aussie Rules" <AussieRu...@no spam.nospamwrot e:

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_GetBanner AdvertDetails is working? Try
to execute it in the Query Analizer (or any other tool to check the db
output)

[Steven Cheng[MSFT]]

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
AutoGenerateCol umns="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.EventArg s) 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(W ebConfiguration Manager.Connect ionStrings("ASP NETTestDBConnec t
ionString").Con nectionString)
conn.Open()
comm = New SqlCommand(sql, conn)

rdr = comm.ExecuteRea der()

AdRotator1.Data Source = rdr
AdRotator1.Imag eUrlField = "name"
AdRotator1.Navi gateUrlField = "descriptio n"

AdRotator1.Data Bind()

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.