I created two tables: Publisher PK, PublisherId, int, not null, indentity +1 PublisherName, varchar(50), not null Product PK, ProductId, int, not null, identity +1 ProductName, varchar(50), not null PublisherId, int, not null Then I created a foreign key constraint FK__Product__Publisher between those tables connecting the Pub...
Hi, Does anybody know of good tools/plugins to organize the dataset designer in Visual Studio 2008? Right now it's a big jumble of TableAdapters without relationship views - it would be very cool if there was a tool available that could organize it, kinda like how it's done in SQL Server Management studio's 'Diagram' pane. Cheers, WT ...
Is there a tool/addin for VS to clean up the design view of a dataset by automatically repositioning the tableadapters, etc based on relationships? Thanks ...
I'm using Visual Studio 2005. I normally use the DataSet Editor to design datasets. However, this option is no longer available in the Open With dialog. Visual Studio now defaults to designing datasets with the XML Schema Editor. How can I get the DataSet Editor restored as an available option when designing datasets? ...
Hi I have a .NET web app built using VS 2008. I included a strongly typed dataset that uses custom types in the table columns. I did this by manually editing the XSD file behind the dataset. This was all working fine until I did a big search and replace to change the name of the project. Now I can't get it working again no matter what I...
Hi, I am using Visual Studio 2008 .Net Framework 3.5 SP1 and get the following error when I save (ctrl-s) a dataset .xsd file within the VS IDE: InvalidArgument=Value of '-2147483648' is not valid for 'RowPosition' Is this somethng anyone has come across? The way I have fixed this in the past is to remove the DataTable and Table...
What does this icon mean is Visual studio, visual Data Set designer. I have several stored procedures. can you help me understand, why the one on top of the list has a small "check mark" why I can't delete it if I need to. This is not the case with the rest. Why is this "special" ? Thanks ...
hi guys i ve a datagrid and wen a button s clicked i want the values from the datadrid to the database.. thanx in advance ...
In visual studio datasource designer is there any way to refresh a table and its relations/foreign key constraints while keeping the custom queries? The way I am doing it at the moment is removing the table and adding it again. This adds all the relations and refreshes all fields. Also if I change a fields data type, is there a way to ...
Can anyone tell me if there are any performance overheads to using the dataset designer as opposed to setting up the data connection using code and manually retrieving the data? ...
Hi, workig with Visual Studio 2008 DataSet Designer has become a pain in the a*s. I have a quite big dataset (>50 Tables) and saving chages takes A LOT of time (I am talking here about 10-15 minutes!). It cannot be a hardware issue since I have an Intel i7, 8 GB RAM and 7200rpm HDD. Has anyone an idea? (This "bug" occurs on every PC wor...
Why this error is appearing? I was just setting some default values in a dataset designer... its second time that this is appearing... "Custom tool error Failed to generate code. Exception of type 'System.OutOfMemoryException' was thrown" ...