All Replies

Posted by Community Admin on 20-Mar-2012 00:00

Hello,
I have made a module (with Radrotator) that get a picturs (from a SQLEXPRESS database) and display it,that work greate,so now i would like to integrate it (like a widget) to used it in my sitesinity 5 project but i get an error about the string connection,where do I défine it ?
The error is , and how can i resolve this problem ?

The connection name 'CantonConnectionString' was not found in the applications configuration or the connection string is empty.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The connection name 'CantonConnectionString' was not found in the applications configuration or the connection string is empty.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

            

            1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

            

              <%@ Page Language="C#" Debug="true" %>

            

            or:

            

            2) Add the following section to the configuration file of your application:

            

            <configuration>

               <system.web>

                   <compilation debug="true"/>

               </system.web>

            </configuration>

            

            Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

            

            Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Thanks

Posted by Community Admin on 20-Mar-2012 00:00

Hey Med,

SQL Connections are stored in the DataConfig.config file. You can find it by going from the root folder of your project to App_Data/Sitefinity/Configuration.

When you open the file, you'll find the default connection string for the Sitefinity database already there.

Jochem.

Posted by Community Admin on 20-Mar-2012 00:00

Thank you for the reply,
I attached the database when I created the project, and I added the connection string ("CantonConnectionString") in the file dataconfig.config but i get this error :

Server Error in '/CantonComm' Application.

The connection name 'CantonConnectionString' was not found in the applications configuration or the connection string is empty.


            Line 45: 
Line 46:         <br />
Line 47:         <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
Line 48:             ConnectionString="<%$ ConnectionStrings:CantonConnectionString %>" 
Line 49:             SelectCommand="SELECT [Id] FROM [ArtisteImageBlog]">

Source File: c:\Program Files\Telerik\Sitefinity 5.0\Projects\CantonComm\App_Data\Sitefinity\WebsiteTemplates\Theme01\WidgetTemplates\widget\Default.ascx Line: 47

Thank you again

Posted by Community Admin on 20-Mar-2012 00:00

Hey Med,

Euhm if I'm not mistaking the <%$ is the culprit, I think it should be <%= instead so you'll get

ConnectionString="<%= ConnectionStrings:CantonConnectionString %>"

I could be wrong but $ can't be used on the server side I believe..

Jochem.

Posted by Community Admin on 20-Mar-2012 00:00

Hey Med,

Your post doesn't show up here but I received it in the email. The problem with the code is your trying to paste .aspx code into an .ascx. (an .aspx is a full page, a .ascx is just a snippet you 'paste into' a full page. So all the doctype/html/form/body etc needs to be removed)

Best way to fix it is to go into VisualStudio and under project select Add new Item. From the new window select "Web user control". This will create an .ascx file with some code behind, and you end up with this:

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="WebUserControl1.ascx.cs" Inherits="SitefinityWebApp.WebUserControl1" %>

Underneath paste the following (from your snippet):

<div>

<telerik:RadRotator ID="RadRotator1" runat="server" DataSourceID="SqlDataSource1" AppendDataBoundItems="True">

<ItemTemplate>

<asp:Image ID="Image1" runat="server" ImageUrl='<%# DataBinder.Eval(Container.DataItem, "Id", "Handler.ashx?Id=0") %>'/>

</ItemTemplate>

</telerik:RadRotator>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%= ConnectionStrings:CantonConnectionString %>"

SelectCommand="SELECT [Id] FROM [ArtisteImageBlog]">

</asp:SqlDataSource>

</div>

And then register the file in the Sitefinity toolbox.

Posted by Community Admin on 21-Mar-2012 00:00

hi Jochem and thanks a lot for your help,
Now I dont have any error but the RadRotator does not display the images,I dont know why ! I just fellow the same steps . I attach the pictures that show that .
Thankx again

Posted by Community Admin on 21-Mar-2012 00:00

Dear Med
I would use Fiddler2.com to see what is happening.What is tried to be loeaded and what's the error.
Markus

Posted by Community Admin on 21-Mar-2012 00:00

Hey Med,

With each step where getting closer no?

Since you're using Chrome as a browser you can right click one of the 'broken image' icons and click 'inspect element'. This will show you the rendered source of the html and might give a clue as to why the images aren't showing. (see screenshot 1)

Next to that you can click the 'resource tab' and reload the page. If you scroll up/down you'll see all individual files being loaded (or not). The ones Chrome couldn't load will show up in red and have a status of 404. (see screenshot 2)

When you hover over the name of that file, a tooltip will show you the exact URL it tried to load it from.

---

To take a guess, I'd say you try and return the image with a 'hardcoded' full url like (http://localhost/image01.png) but you're browsing the website to Sitefinity's projectmanager which operates not on port 80 but (in your screenshot 60876). If you let your .ashx return the images with a relative path (/image01.png) it should work better.

But this is just a guess based on the previous postings.

Jochem