Adrotator
in [ASP .NET]
|
Prev: ThreadAbortException at ExportToHttpResponse()
Next: Ajax PageRequestManagerServerErrorException unknown error afterappliocation is idle
From: Aussie Rules on 4 Jun 2007 15:31 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"
From: Alexey Smirnov on 4 Jun 2007 16:41 On Jun 4, 9:31 pm, "Aussie Rules" <AussieRu...(a)nospam.nospam> wrote: > 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
From: Steven Cheng[MSFT] on 4 Jun 2007 23:35 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.
From: Aussie Rules on 5 Jun 2007 13:26 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]" <stcheng(a)online.microsoft.com> wrote in message news:842F4NypHHA.2368(a)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" <alexey.smirnov(a)gmail.com> wrote in message news:1180989678.504452.41390(a)i13g2000prf.googlegroups.com... > On Jun 4, 9:31 pm, "Aussie Rules" <AussieRu...(a)nospam.nospam> wrote: >> 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 >
From: Alexey Smirnov on 5 Jun 2007 14:54
On Jun 5, 7:26 pm, "Aussie Rules" <AussieRu...(a)nospam.nospam> wrote: > 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 |