Stack Overflow
Stack Overflow

Questions tagged [dataset-designer]

48 questions
23
votes
6 answers

"Cannot change DataType of a column once it has data" error in Visual Studio 2005 DataSet Designer

I've got a DataSet in VisualStudio 2005. I need to change the datatype of a column in one of the datatables from System.Int32 to System.Decimal. When I try to change the datatype in the DataSet Designer I receive the following error: Property…
firedfly
  • 2,299
  • 2
  • 22
  • 20
8
votes
6 answers

Visual Studio DataSet Designer Refresh Tables

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…
Michal Ciechan
  • 13,492
  • 11
  • 76
  • 118
4
votes
3 answers

Visual Studio DataSet Designer Saving is VERY slow

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…
Cav
  • 162
  • 3
  • 13
3
votes
1 answer

Tools to organize Dataset designer?

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,…
Donnie Thomas
  • 3,888
  • 8
  • 47
  • 70
2
votes
0 answers

How to get Microsoft.Data.SqlClient to work with DataSet Designer?

Quite simply, how do you get Datasets Designer in visual studio to use Microsoft.Data.SqlClient as a provider? I did the following in a NetStandard2.0 Project. Add nuget Microsoft.Data.SqlClient Add new Dataset to project. Opened the dataset…
Gaz83
  • 2,293
  • 4
  • 32
  • 57
2
votes
0 answers

A TableRow referenced trought a DataRelation always returns null

Using the DataSet designer in Visual Studio 2010, I've added some tables from a MySql DB. VS10 automatically picks up and adds the relations between the tables, e.g., the relation "FK_organisatie_adres" between the tables "Organisatie" and…
Robbie
  • 715
  • 3
  • 10
  • 18
2
votes
1 answer

Dataset Designer Performance Question

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?
Paul Michaels
  • 16,185
  • 43
  • 146
  • 269
2
votes
2 answers

visual studio DataSet designer with stored-procedures ? what is this icon

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…
Asad
  • 21,468
  • 17
  • 69
  • 94
1
vote
1 answer

OleDbCommand.Prepare method requires parameters of type '14' have an explicitly set Precision and Scale

Using Visual Studio 2010 and I'm encountering an error when attempting to use the DataSet designer. The error is as stated in the subject, "OleDbCommand.Prepare method requires parameters of type '14' have an explicitly set Precision and Scale." I…
McArthey
  • 1,614
  • 30
  • 62
1
vote
1 answer

SQL Get Specific Multiple ID's from TableAdapter using string (like IN expression)

I'm using a DataSet Designer in my program. In my database I have a primary key ID_Item and I want to fetch some specific ID's from the database table (dB). Using the Add Query.. from the DataSet Designer | Table | TableAdapter. It creates a query…
Alex McIntosh
  • 21
  • 4
1
vote
2 answers

Having trouble dealing with completely legit DBNULL. Using DataSets DataTables being passed as the Model data Views. ASP.NET MVC2

I'm loving MVC but unfortunately all the tutorials, demos and ALL resources use Entity Framework to generate ViewData and most use LINQ to SQL instead of DataSets. I'm reusing existing business logic and the client (who is a great coder in his own…
korz
  • 53
  • 4
1
vote
1 answer

WPF DataSet/Query Designer VS2010

Is there any good Dataset designer control similar to "Crystal Reports Database Expert", which I can provide in my application. All I need to do show tables and Let the users establish relationships between those tables and select fields to view. As…
Bhuvan
  • 1,523
  • 4
  • 23
  • 49
1
vote
1 answer

What generates DataSet.designer.vb files

I have continually run into problems trying to repair code from another developer, and one method I opted to go with was manually changing the generated dataset.designer.vb file to include overloaded database CRUD methods... After some searching,…
William Tolliver
  • 305
  • 1
  • 2
  • 16
1
vote
3 answers

Custom tool error Failed to generate code

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"
Dr TJ
  • 3,241
  • 2
  • 35
  • 51
1
vote
0 answers

Typed Dataset designer, I need to fill multiple tables with a single database call where the stored procedure returns multiple resultsets

It is possible to achieve the following: On the Dataset designer, I create three tables and then with a single data adapter call a stored procedure that returns three result sets that I need to fill into these three tables. I have tried the…
Moiz Tankiwala
  • 6,070
  • 7
  • 38
  • 51
1
2 3 4