Windows Develop Bookmark and Share   
 index > Windows Forms Data Controls and Databinding > Unable to Edit Relation in DataSet Designer in VS2008
 

Unable to Edit Relation in DataSet Designer in VS2008

Hi, I have a project with a DataSet, a number of DataTables and relations between them. I upgraded the project so I could work on it in the RTM release of Visual Studio 2008 but I am unable to edit those relations. Either VS2008 bombs out completely (and Vista restarts it) or I get "Operation Failed", "Object reference not set to an instance of an object" when ever I try to Edit a Relation.

I can delete a relation and successfully create a new one but I still cannot go back and edit it.

Is this a known issue? If not how should I try and resolve it? Since I'm in the designer and not running my application how can I debug this?

Regards

Jayne

Jayne2  Friday, November 30, 2007 1:33 PM

I am unable to reproduce this problem you are mentioning. Can you please give us details steps to produce the problem (If possible, can you please try with the sample database - northwind database)

Naga Satish Rupenaguntla  Friday, November 30, 2007 11:17 PM

Hi Jayne,

We are changing the issue type to "Comment" because you have not followed up with the necessary information. If you have more time to look at the issue and provide more information, please feel free to change the issue type back to "Question" by editing your initial post and changing the radio button at the top of the post editor window. If the issue is resolved, we will appreciate it if you can share the solution so that the answer can be found and used by other community members having similar questions.

Thank you!
Rong-Chun Zhang

Rong-Chun Zhang  Thursday, December 06, 2007 7:21 AM

Ihave this same issue. I can delete and recreate the data relation. I cannot edit it. I can right click the relation and select edit relation and get an error box. Operation failed. Object reference not set to an instance of an object.

If I double click the relation, I get a hard crash that closes Visual Studio 2008.

David Partridge  Monday, January 14, 2008 5:38 PM

I have exactly the same problem

Christian Gessner  Tuesday, May 13, 2008 9:29 AM
I have the same problem mentioned above. I can create relations, but if I right-click and try to edit, I get the error, "Object reference not set to an instance of an object". Occasionally, VS dies.

T. Ray Humphrey  Friday, June 06, 2008 6:35 PM
Me too. Simple dataset with two datatables. Happens every time. VS2008 RTM, Vista Business x64 SP1, Quad-core, 8GB physical ram. SQL Server 2005 Installed locally. Can post xml if required.

alasdaircs  Thursday, June 19, 2008 9:58 AM
Same here...
Zvjezdan T  Sunday, July 27, 2008 5:33 PM
Although my DataSet is in nested namespace.
Can it have something to do with it?
Zvjezdan T  Sunday, July 27, 2008 5:37 PM

I have the same problem. But it only seems to happen to me when the table adapter query commands are set to use stored procedures.

-andy

Andeezle  Monday, August 11, 2008 10:13 PM

I am experiencing the same problem as well. Except I can not even add a new project datasource via the wizard.

When i do, i select my database, connectionstring and then a simple select * from a given table.

As soon as i click on FINISH, i receive this error and vs2008 crashes.

I think this may have something to do with connecting or oracle, but then again, why would the wizard allow me to see all of my tabels and stuff?

Any clue would be appreciated.

Thanks,

Bill

wmbrand  Thursday, August 28, 2008 3:12 PM

Any solution for this problem?

Menhir666  Monday, July 27, 2009 6:37 PM

You can use google to search for other answers

Custom Search

More Threads

• Binding to a list of custom objects
• Bindind controls using inherited class does not display updates (Visual Basic Express)
• Any controls like Sybase's datawindow?
• DataGridViewTextBoxCell.GetFormattedValue Strange Behaviour
• Save DataTable to dbf file
• Changing the datasource of a bound textbox
• Datagridview and cell validation???
• Sort glyph position in column header
• how to select all items in a list box
• Master-Detail Issue