.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

Custom Data Source Problem

Posted By:      Posted Date: October 02, 2010    Points: 0   Category :Sql Server
 

I created a data model in BIDS, built a report from the data model in Report Builder 1.0, and saved to our report server.
When I run the report from the Report Manager it runs fine.

I am trying to modify the report for Data Driven Subscription.
When I setup a Custom Data Source and enter the same credentials that work fine in the Shared Data Source,
I get a very strange error:

An error occurred during client rendering.
An error has occurred during report processing.
Query execution failed for dataset 'dataSet'.
Incorrect syntax near '<'. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The floating point value '6e2909' is out of the range of computer representation (8 bytes). The floating point value '6e2909' is out of the range of computer representation (8 bytes). The floating point value '22e84222201' is out of the range of computer representation (8 bytes). The floating point value '6e2909' is out of the range of computer representation (8 bytes). The label 'xsi' has already been declared. Label names must be unique within a quer


View Complete Post


More Related Resource Links

Connecting a Sharepoint Custom list with an external Data-source

  
Hi I am planning to connect a Sharepoint Custom list with an external Data-source. External DB will be in Access 2007 format. More Information: I need a solution that we can connect our sharepoint list (one-way) to online db in a way that new  information is directly updated in the sharepoint list, whilst other info changed in sharepoint list  is not synced back to original value. Is there a way to solve this? -saumil

FormView custom data binding problem

  
Hi there,   I'm using VWD 2010 ASP.NET 4.0 and SQL Server 2008 Also I have login page with the ASP.NET configuration   one of my page has FormView with Update feature   Evryting works fine user login go to my FormView page and update the record.   Now I created a simple function   Protected Function GetUserName() As String        Return User.Identity.Name    End Function   and one of my coloumn call EditedBy   I replaced the Bind("EditedBy") field binding with   Custom binding GetUserName()   When user update it show the current user login name on the screen But it won't show in the table itself (it show null value when i do select statement)   I used to do this with ASP.NET 2.0 with no problem?   How do I fix that?   Thanks, Oded Dror  

Problem with adding custom propety to a data class using Linq.

  

Hello,

I tried to add a custom property to the data model:


public partial class Department
    {
        public string ExtensionIdName
        {
            get
            {
                return Extension.ExtensionName;
            }
            set
            {
            }
        }
    }

It seems that it works, but when I bind the data to a ListView it shows all the properties except the property I added manualy (ExtensionIdName).

Am I missing something or is there something wrong?


problem with sql data source - view with INNER JOIN

  

Hello!

I have a question. I created a new data source (sql database connection) - a view that contains INNER JOIN statement. After that I created a page and put Edit Item Form on it based on this data source. When I open a page and try to update some records I get an error: "The data source control failed to execute the update command."

There is no error when I use a view without INNER JOIN...

Can I solve it? Should I write my own UPDATE statement?

Thank you.


Custom Shared Data Source (SHP Integrated Mode)

  

I've seen this answer for Reporting Services several times: "You cannot use a data source expression in a shared data source".

My question is: Is there any chance to use data source expressions in a shared data source at Sharepoint (Report Builder 2.0)?

Thanks in advance,

Jorge Blanco


MySql.Data assembly problem

  

Hi,

I added refernece MySql.Data to my project. My web.config looks like that:

<?xml version="1.0"?>
<configuration>
    <connectionStrings>
    </connectionStrings>
    <system.web>
        <compilation>
            <assemblies>
                <add assembly="MySql.Data, Version=6.1.4.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>
            </assemblies>
    </compilation></system.web></configuration>


But when in ServerExplorer I try "Add Connection..." I can't find "MySql Database" in the "Choose Data Source" dialog box?


What the problem can be?





Toolbox: Data Snapshots, Subversion, Source Code Organization and More

  

If you want to save, organize, and annotate snapshots of your database data, find an easy way to install and configure Subversion, and automate the organization of your source code, then you'll want to read more about these latest tools.

Scott Mitchell

MSDN Magazine August 2009


Data Points: Data Bound Applications with ADO.NET and Custom Objects

  

In this column see how to bind a custom list of business entities using the binding tools in the .NET Framework 2.0.

John Papa

MSDN Magazine February 2007


Extend ASP.NET: Simplify Data Binding In ASP.NET 2.0 With Our Custom Control

  

The wwDataBinder control addresses simple control data binding--binding simple form controls like textboxes, checkboxes, and the selected values of list controls to individual data or object values.

Rick Strahl

MSDN Magazine December 2006


SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services

  

Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006


Cutting Edge: Custom Data Control Fields

  

In ASP. NET 2. 0, the GridView and DetailsView controls are designed to work together. They don't merely provide complementary services, they also share a number of helper classes and components. The output of the GridView control consists of a sequence of rows, each with a fixed number of columns.

Dino Esposito

MSDN Magazine January 2006


Cutting Edge: Flexible Custom Data Views

  

ASP. NET 1. x introduced some powerful and useful data-bound controls. However, none were designed specifically to manage the view of a single record. When you build master/detail views, you need to display the contents of a single record.

Dino Esposito

MSDN Magazine December 2005


Data Binding: Give Your Everyday Custom Collections a Design-Time Makeover

  

In this article, Paul Ballard shows how you can provide data binding support for your custom collections to enable sorting, searching, and editing in as simple a manner as possible. In addition, he shows how to make all of these features available in the Windows and Web Forms Designers, just like an ADO.NET DataSet.

Paul Ballard

MSDN Magazine August 2005


SQL Server: Display Your Data Your Way with Custom Renderers for Reporting Services

  

SQL Server 2005 Reporting Servicesis a great tool that offers a centralized approach to storing and rendering reports. It also lets users view and download reports without installing additional software. Plus, reports can be saved in any number of different formats using custom report renderers. In this article, the author will develop one such report renderer that outputs HTML reports, but the skills you'll learn can easily be used to create a renderer for Microsoft Word documents or any other format of your choosing.

James Yip

MSDN Magazine February 2005


Data Points: Data Source Controls in ASP.NET 2.0

  

ASP. NET 2. 0 introduces a series of new tools that improve data access including several data source and data bound controls. The new assortment of data source controls can eliminate a ton of repetitive code that was required in ASP.

John Papa

MSDN Magazine January 2005


Data Deployment: Streamline Your Database Setup Process with a Custom Installer

  

Database setup can be a tough and time-consuming process and sometimes fall victim to human error. Microsoft Installer or InstallShield can help, as can your own custom installer. In this article, the author tackles one approach to writing database installers and demonstrates the process with a working code sample.

Alek Davis

MSDN Magazine September 2004


ADO.NET: Building a Custom Data Provider for Use with the .NET Data Access Framework

  

The System.Data.dll assembly in the .NET Framework contains namespaces whose base classes can be used to create custom data providers. These namespaces also define a number of data access interfaces and base classes that let developers create data providers that will interoperate with other custom providers. Using the ADO.NET classes Connection, Command, DataReader, and DataAdapter, writing a provider is easier than writing one for OLE DB. This article explains these classes and their implementation, and how they can be used to write a variety of different kinds of data providers.

Bob Beauchemin

MSDN Magazine December 2001


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend