Stack Overflow
Stack Overflow

Questions tagged [dataset-designer]

48 questions
1
vote
1 answer

Why does the Visual Studio DataSet Designer generate such complicated queries?

I've got a simple table in an MS Access database: ------------------- | Programs | |-----------------| | Id (PrimaryKey) | | Name | | Path | | Notes | ------------------- Then using the Visual Studio wizard I…
Plain Coder
  • 993
  • 1
  • 8
  • 13
1
vote
1 answer

Why should we separate DataSet code from DataAccess code?

I've been converting my WinForm application using a tiered approach following this article: http://msdn.microsoft.com/en-us/library/vstudio/bb384570.aspx In the article, it recommends creating two separate class libraries, one for the typed DataSet…
discofighter411
  • 19
  • 8
1
vote
2 answers

.NET - using a custom type in a dataset

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…
Mark
0
votes
1 answer

Selecting a particular query in the dataset designer to be used in the fill method of the table adapter?

I created a new query in the dataset designer. There are now 2 queries there. The original one and the new one. I also added named parameters in the Where clause of the 2nd query. This is the query in the new one: SELECT ID, FatherName, MotherName,…
Emad-ud-deen
  • 4,734
  • 21
  • 87
  • 152
0
votes
2 answers

Using .Net DataSet Designer and NVL()

For the first time I am trying to create a DataSet/TableAdapter in the VS2010 DataSet Designer using a query with a join and function; NVL(). Typically I had only used single database tables by dragging them to the designer workspace from the…
McArthey
  • 1,614
  • 30
  • 62
0
votes
1 answer

Why is dataset designer changing the case of my schema objects?

I have two xsd files with the same exact schema. The first was generated from an SQL connection and the other was generated from a FoxPro OleDb connection by the Dataset Designer. I can't use the same XSD for generating my table adapters and…
ATL_DEV
  • 9,256
  • 11
  • 60
  • 102
0
votes
1 answer

Can DataSet designer in VS2010 support optional parameters?

I like a lot of the built in features the built-in DataSet designer provides in VS2010 and do not want to have to change to something entirely different if at all possible. The problem is, to have optional parameters, I need to create completely…
just.another.programmer
  • 8,579
  • 8
  • 51
  • 90
0
votes
2 answers

Why do typed DataSet methods return unexpected results

I use typed DataSets for accessing data, configuring them via DataSet Designer (the general idea is explained in this tutorial). For each table a GetData() method is automatically created at first. It returns a DataTable having the same schema (i.e.…
Kirill
  • 3,028
  • 1
  • 17
  • 18
0
votes
0 answers

NET Core Visual Studio Database Designer adds Properties and OleDB references

I'm trying to port a NET Framework 4.7.2 class library project to NET Core 3.1 (or 5.0). The project uses a database through the System.Data.Odbc Nuget package. The problem is that the Visual Studio Database Designer generates code that references…
Kevin
  • 1,548
  • 2
  • 19
  • 34
0
votes
2 answers

Extend DataSet Class Not Working

I've created a dataset using the dataset designer. One of my tables is called Users and so there is a class called UsersDataTable. In this class are some properties, namely Connection. So I created a Partial Class UsersDataTable, but none of the…
cjbarth
  • 4,189
  • 6
  • 43
  • 62
0
votes
2 answers

Syntax for Getting/Setting DataSet Row in Visual Studio

Using Microsoft's How to Guide, I have created a database within a word VSTO project. After this, I used another How to Guide to create a dataset from this database. Now I am trying to get/set the data in the dataset's tables using the following…
Tullocco
  • 11
  • 5
0
votes
1 answer

Strongly Typed Dataset designer resets AllowDbNull on parameter

I'm working on updating an existing application that relies heavily on Strongly Typed Datasets. The original developer created a lot of very similar queries on each dataset to handly any combination of parameters possible, which is a pain to update.…
Julien N
  • 3,880
  • 4
  • 28
  • 46
0
votes
1 answer

Extend View and Dataset of new column. Giv empty columns only new columns

I have problem with new columns in datagrid. I have many columns but I need to add 3 more. In SQL Server 2008 Management Studio, I design the view and add more columns that exist in the ViewTable "V_FKD". In VS2008 DataSet Designer. I add fine…
David
  • 21
  • 4
0
votes
1 answer

How work DataSet TableAdapter Properties Connection - "ConnectionString(Settings)". It's temporary?

In small company I have a big problem with make changes in bigand old counting program(GS). When we have old empty connection string in TableAdapter in DataSet all work fine. When i update view in DB, make new string to DB in TableAdapter. All…
David
  • 21
  • 4
0
votes
1 answer

Visual Studio Dataset Save unexpected fail

When a Dataset on a sqlite database is configured with wizard, some times show weird behavior. Any edit to dataset designer may result to dataset fail (automatically being removed from datasources pane) when try to save.
anefeletos
  • 672
  • 7
  • 19
1
2
3 4