Stack Overflow
Stack Overflow

Questions tagged [tableadapter]

a .Net component, that fills a dataset with data from the database.

TableAdapter is a component, that fills a with data from the database.

505 questions
2
votes
3 answers

TableAdapter to return ONLY selected columns? (VS2008)

(VS2008) I'm trying to configure a TableAdapter in a Typed DataSet to return only a certain subset of columns from the main schema of the table on which it is based, but it always returns the entire schema (all columns) with blank values in the…
MattSlay
  • 9,115
  • 5
  • 43
  • 52
2
votes
2 answers

ADO.NET databinding bug - BindingSource.EndEdit() changes current position

What is the correct order of processing an insert from a data-bound control using BindingSource, DataSet, and TableAdapter? This is causing me eternal confusion. I have a form that is used to add a new row. Before showing the form, I…
cdonner
  • 37,019
  • 22
  • 105
  • 153
2
votes
0 answers

Connection string in web.config when using Net Standard 2.0

We have an old project that has been running for over 10 years, and now we tried to update parts to net standard 2.0. Earlier it was possible to set a connection in the DataSet that could be changed with an entry in web.config. If you check the old…
Hoben
  • 49
  • 3
2
votes
1 answer

C# bound textbox will not update using tableadapter update

I am having problems getting a dataset to update changes to a database. I start by filling a dataset using a FillBy query that I created on a table adapter. "SELECT * FROM tblTest WHERE testID = (testID = @testId) That will return a single record. I…
OverStacked
  • 31
  • 1
  • 8
2
votes
1 answer

Option Strict On and SQL stored procedure output parameter of nullable integer

There are several topics in this forum that come tantalisingly close to providing an answer to my question, but not quite what I need. I am writing in VB.Net, retrieving data via TableAdapters and stored procedures. The stored procedures can return…
Neil Miller
  • 23
  • 6
2
votes
2 answers

tableadapter.update doesn't work?

I have a problem that drives me crazy... I have a local database (.sdf) on my PC en a database on the internet (MySQL), both with same structure. I first load data from the internet in the dataset via the dataadapter and secondly I load some local…
Lars Boele
  • 375
  • 2
  • 10
  • 26
2
votes
2 answers

Database isn't updating

I am trying to write some data into a .MDF database that has only one table, and it's not updating after I execute this part of the code: DatabaseDataSet.MyTableRow newRow; newRow = databaseDataSet.MyTable.NewMyTableRow(); …
deckard cain
  • 497
  • 10
  • 24
2
votes
5 answers

ASP.net c# database connectivity getting into a mess

I'm just starting development on a new website and am trying to do it correctly, that is, with a DAL and not with queries in code which I had before. I understand the principles of it all, but I am finding this DAL with table adapters and wizards…
Tom Gullen
  • 61,249
  • 84
  • 283
  • 456
2
votes
2 answers

TableAdapter Fill doesn't update database

I want to insert data into MS Access using a DataSet and TableAdapters, but unfortunately it doesn't update the table in MS Access when I run this code: DataSet2TableAdapters.Tabelle1TableAdapter tabelle1TableAdapter = new…
user5747953
2
votes
1 answer

Big difference in execution time of stored proc between Managment Studio and TableAdapter

How could a stored procdure run in 10 seconds via Management Studio, but take 15 minutes via a TableAdapter for the same inputs? It is repeatable, meaning I have run it at least three times in each environment, and Management Studio is consistently…
recursive
  • 83,943
  • 34
  • 151
  • 241
2
votes
2 answers

XSD file fails to open in table design mode in Visual Studio 2017

Some XSD files are opened immediately in Design view (see image below). While others in the same solution are opened in the table design view (where I see the table adapters visually). I already checked here, but when I try to open it with the XML…
Adam
  • 6,041
  • 36
  • 120
  • 208
2
votes
2 answers

c# - Tableadapter not working because of timeout

My TableAdapter is defined in an ADO.NET data set. My stored procedure is executed in 50 seconds in SSMS. When I'm trying to execute it in application I get timeout. How to set timeout connection value for TableAdapter?
Piotr Bogusz
  • 21
  • 1
  • 2
2
votes
1 answer

c# (3.5) use TableAdapters to read/write null DateTime values to a database

I am connecting to a database using VS2008 DataSets. One of the Tables within the database contains a DateTime Column that allows nulls (i.e. Type: DateTime?) MSDN Datasets categorically states: The Nullable or Nullable structure is not currently…
TK.
  • 46,577
  • 46
  • 119
  • 147
2
votes
4 answers

How do you filter a TableAdapter's FillBy based on two tables?

I'm using VS2008 C# Express and the Northwind database on a Windows Form application. I used drag and drop to set up the master details binding (I used the Orders and Order Details) for the two datagridviews. At this point, everything works as…
user45191
  • 61
  • 1
  • 1
  • 7
2
votes
5 answers

Do I need to use database transactions with c# TableAdapters?

I found this great article on Transactions with Table Adapters. However, this article doesn't explain why Transactions are needed or even desirable! Why would it be worth me trying to implement Transactions alongside my TableAdapters?
TK.
  • 46,577
  • 46
  • 119
  • 147
1 2 3
…
33 34