Stack Overflow
Stack Overflow

Questions tagged [dataset-designer]

48 questions
0
votes
0 answers

dataset designer relation and crystal report

I am using datables in dataset.xsd designer visual studio 2012. I have three tables tblA,tblB and tblC tblA (parent) --- ----> tblB aid bid tblB(parent) -- ----> tblC nid nid if tblB is empty then…
user good
  • 107
  • 2
  • 9
0
votes
1 answer

ParentRelations don't work in generated DataSets?

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…
Mephisztoe
  • 3,276
  • 7
  • 34
  • 48
0
votes
1 answer

Visual Studio 2013 Dataset Designer Does Not Match Code

I am having a problem with the Dataset Designer in VS2013. I don't know how it happened but when I go to view a Dataset in the designer, a ton of my queries and stored procedures are missing. It's almost like the designer rolled back to defaults or…
waltmagic
  • 631
  • 2
  • 9
  • 22
0
votes
0 answers

get child notes without dataset. dataset designer

I used the dataset designer to access the database. And I do not understand why I'm getting no data. Please tell me how to fix that usersTableAdapter usersTA = new usersTableAdapter(); var usersTable = new…
Georgy Tarasov
  • 1,534
  • 9
  • 11
0
votes
1 answer

filtering the dataset in a combobox based on data in the it's bindingsource

I have built a combo box that uses a dataset with 2 tables, in order to perform a lookup for the values to display, but save a different value back. It was built from this great blog (her first item of the two in the…
da Bich
  • 494
  • 1
  • 4
  • 13
0
votes
0 answers

Accessing Strongly Typed DataSet in an ASP.NET Web Site

I have an ASP.NET 4.5 Web Site that I'm creating in VS2012 , and I'm having issues trying to access the strongly typed DataSet that I created for it. I used the DataSet Designer to create the dataset in the App_Code folder. I know the App_Code…
Evan M.
  • 211
  • 1
  • 4
  • 13
0
votes
1 answer

Swap Database in visual studio from Access to SQL

I have created a windows form project which is based in vb.net in Visual Studio. This form acts as the front end to the database. I decided this time round to try use the Dataset Designer in Visual Studio and found it convenient. Using the Wizard I…
steambop
  • 13
  • 4
0
votes
2 answers

Cannot insert default value into SQL database from Win Forms project

I have a MS SQL database. On one of my fields, LotNumber I set the default value to be [dbo].CalculateJulianDate which is a scalar-valued function that takes the current date and creates a Julian date formatted lot number. When I insert values into…
gwhenning
  • 138
  • 1
  • 3
  • 14
0
votes
1 answer

Remove rows in database by Dataset with relationship in SQLite

i have simple database and dataset, which looks like: file: myDb klasa = class room nauczyciel = teacher klasa data: teacher data: now i want to remove teacher, which has ID equals 2: it's whole code: DataSet2 db = new DataSet2(); …
Marek Woźniak
  • 1,766
  • 16
  • 34
0
votes
1 answer

Insert method not behaving as expected

I've made my entire database for my application using only VS2012 express (I'm using localdb), so it handled creating the database as well as creating datasets and table adapters for my application to use. It's worked very well so far. I've also…
ldam
  • 4,412
  • 6
  • 45
  • 76
0
votes
1 answer

How does Visual Studio dataset designer work when creating table adapter based on procedure

I need to update dataset table adapter in Visual Studio 2010. It is based on a stored procedure. The store procedure has parameters @IDportfolio INT , @Date varchar(50) = NULL , @IDorder int = NULL , @IDsession…
gljivar
  • 440
  • 7
  • 19
0
votes
1 answer

Writing a Data Facade class library vs. Including it in the Data Access layer

I am writing a simple data- displaying app that has a UI presentation layer, a data access layer, and a commons layer which includes the data sets. Since this application will be relatively light weight (no writing / updating data) I figured it…
discofighter411
  • 19
  • 8
0
votes
1 answer

Reference a generated dataset

How would I reference and pull data out of a generated dataset? I have 2 projects in the same solution. (1) MyUIProject (2) MyDataSetProject ->MyGeneratedDataSet.xsd -->-->MyNamesTable (in the dataset) All I want to do is reference the MyNamesTable…
MissioDei
  • 809
  • 2
  • 12
  • 19
0
votes
2 answers

Update method of DataSet.xsd doesn't changed DataBase, Why?

I made a DataSet.xds file with VS wizard. Select part of tables works properly. Now I want update a record from a table, I used codes below. private void AuthorsTableAdapter(DataRow changedDataRow) { authorsTableAdapter adapter =…
Parham.D
  • 1,158
  • 2
  • 12
  • 31
0
votes
1 answer

DataSet Designer creates different CommandText for different tables

This is an odd question, and I hope I framed it correctly. I am using the Visual Studio DataSet designer to create SQL table adapters to link my project to a SQL server. The connection string is via an ODBC entry. All tables have default queries,…
sbenderli
  • 3,654
  • 9
  • 35
  • 48
1 2
3
4