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


Top 5 Contributors of the Month
david stephan
Post New Web Links

problem with sql data source - view with INNER JOIN

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :SharePoint
 

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.




View Complete Post


More Related Resource Links

Data Source View Gives incorrect Error--Different Data Type

  
Hi, I'm creating a report model (2008 R2).  I am trying to create a relationship between two tables.  One FKs to another--same name and type (tinyint) columns.  But the Data Source View editor doesn't allow this, giving the message "...source and destination column have different data types".  But the columns are the same types.  I ahd this once before  acouple of years ago and don't remember how I got around it. Does anyong have ideas?  

Data Source View

  
I followed this below procedure for create a DataSource View In Solution Explorer, right-click Data Source Views, and then click New Data Source View. On the Welcome to the Data Source View Wizard page, click Next. The Select a Data Source page appears. Under Relational data sources, the Adventure Works DW data source is selected. Click Next. On the Select Tables and Views page, you select tables and views from the list of objects that are available from the selected data source. You can filter this list to help you in selecting tables and views. ( My probelm comes in 4th step, I see my server name in Relational Data sources area, i click next to select Tables & Views but i dont see any list of tables in there..? What am i Missing? Today is my day one on SSAS...please HELP FM

SSRS 2008 R2 Data Source View Wizard does not recognize unique key constraints on views when using O

  
Hi, SSRS Data Source View Wizard does recongnize Primary/Foreign Key relationships from oracle datasouce tables, but does not recognize unique key constraints on views. How can I solve this problem. Thanks

Problem of data grid view of xml file

  
Dear Friends I have a problem with XML View Data Grid. Earlier I create .xml file, then type first set of data tags then Right Click on it and select View Data Grid and Visual Studio 2005 gives me nice data grid view where I can able to enter data. But in Visual Studio 2008 I am not able to find that option. So friends kindly tell me how to enter data with data grid in xml file? I am using ASP.net with  C#, Visual Studio 2008, XML file for createing data source. Thank you.

problem when passing data from view back to controller?

  

I have following situation - I am pasing user info object from Controller to View. It contains GUID UserID,  which i dont want to be seen on page.

So I  removed every   Html.LabelFor(model => model.UserID), Html.TextBoxFor(model => model.UserID) etc... from generated View source.

And because of this when Html.BeginForm() returns that object back to Controller  all values is there but UserID is lost??


If I leave Html.LabelFor(model => model.UserID), Html.TextBoxFor(model => model.UserID) etc.. in View everything is fine.

But I dont want to show UserID?

Where is the problem here?



                <%= Html.LabelFor(model => model.C__User_Id) %>
            </div>
            <div>

Data view web part: Change Data Source

  
I have a data view web part that I would like to use multiple time in the same page, but tied to different sharepoint lists.  Is there an efficient way to do this?

I can add additional data sources, but I don't see how I can remove the original.

Custom Data Source Problem

  

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

Data View Web Part, update to Data Source / adding new list to existing data source

  

Hi all,

I have four Lists with identical columns :

List 1
List 2
List 3
List 4

I had to merge them, hence i created a data source ( Linked Source ) and merged these lists in SPD. I have used a data view webpart to display some columns from the merged lists data source and everything was working fine.

But now i have a new List : List 5 which also has the same columns like the other four lists and i need to update the data soure such that it is merged list of 5 lists not 4.

i updated the datasource property of the linked source to merge this new list as well. However the contents of List 5 dont appear in the data view webpart. 

Am i missing something here ? 

I dont want recreate the data view web part from scratch eachtime , because in future there might be List 6 , List 7 as well ... 


Refresh data source view gets 'column' argument cannot be null

  
When I try to refresh a data source view in SQL Server 2008 BIDS, I get the error: System.Data   'column' argument cannot be null.  Parameter name: column.   How to resolve this?  The underlying tables have no data yet.

Change data source view for dimension

  

Is it possible to change the data source view the dimension gets the table definition from?

Basically I would like to restructure the ds views and dimensions I created earlier are reading from ds views that are no longer appropriate.   Tables would be exactly the same.


Getting error while creating Data Source View in SSAS 2008

  

All,

Getting below error while creating data source view from wizard in SSAS 2008, at the time of clicking "Finish" button. However, created data source successfully.

 

TITLE: Microsoft Visual Studio

------------------------------

 

The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

 

------------------------------

BUTTONS:

 

OK

------------------------------


 

 

 


i have facing debugging problem for not view proper format data

  

i have facing debugging problem for not view proper format data, i have also attached "debug.png" file.please help me how to resolved. Is there any setting require for windows7 x64bit Enterprise with visual studio 2005. please give solutions as soon as possible. Appreciated in advanced 

Id = { _a=704028889 _b=11913 ...} Instead of Guid

ds = 0x000000001d77c818 { KEY_XMLSCHEMA="XmlSchema" KEY_XMLDIFFGRAM="XmlDiffGram" defaultViewManager=<undefined value> ...} Instead of dataset

 


Why shouldn't I snowflake a date dimension to a table in my data source view that's not a fact?

  

This is quite difficult for me to communicate so please bear with me.

I have created my data source view in my solution. I have a central fact table surrounded by the dimensions. Several of the dimensions have dates which I converted to integers. Thinking that I would need separate date dimension tables so the date integers could find their dates I created a data dimension table "snowflaked" to the dimensions with dates.

An example is my dimPolicy table has dates of creation and ending.

I converted these to integers.

A table called dimPolicycalendar was made in the DSV and then linked. A dimension snowflaked to a dimension.

When I went to create a dimension for Policy it auto attached the dimPolicyCalendar. Then all my dates disappeared. And the generic values in the dimPolicyCalendar appeared.

HELP HELP HELP PLEASE!!!

How do I get my values back?

If I wasn't supposed to add a calendar table to the dimension how will I convert those integer values to the date values I want?

I am panicking a little because I can not find any helpful resources.

You are my last hope before we are pushed to an Oracle solution. Yuck!

 

 


BJ Gordon

WebDev.WebServer.exe has encounted a problem and needs to close when trying to view page in browser

  

Hi, whenever I load an aspx page in vwde2008, I get the message in the subject of this post.  After I click Ok on that, I get a dialog box, Unable to Connect to the ASP.Net development center.  What can I do to troubleshoot?

I am using Windows XP SP3, vwde2008 with SP1, on a HP desktop.  Also using Office 2003 if that is relevant at all.

Thanks, Justin


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


Vista and Office: View Data Your Way With Our Managed Preview Handler Framework

  

Stephen Toub shows you how to write your own Preview handlers for Windows Vista and Outlook 2007.

Stephen Toub

MSDN Magazine January 2007


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