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
1 answer

Failed to get schema for this query Visual Studio 2015

I have a page in my program which has a DataGridView object on it. It is populated by a query that selects data from the database table called DOCS. The table has 4 columns: applicant_name doc_id doc_name doc_contents I'm trying to add a delete…
Marko Vidalis
  • 331
  • 1
  • 7
  • 18
2
votes
2 answers

C# WinForms - how to send updates from DataGridView to DataBase

I have a .mdb file with a Customers table and an Agents table. The only thing that the Agents table does as yet is populate the Agent dropdown for each customer... I have a DataGridView linked to the customerBindingSource. The customerBindingSource…
ClarkeyBoy
  • 4,934
  • 12
  • 49
  • 64
2
votes
2 answers

C# TableAdapter for both Access and SQL Server

I'm attempting to create a piece of software that allows a customer to upload data generated by a piece of equipment into their own database. To do this I designed a dataset in Visual Studio 2015 based on a *.mdb file with the desired tables. The…
Jonathan Riger
  • 33
  • 7
2
votes
0 answers

c# Tableadapters and "The specified DSN contains an architecture mismatch between the Driver and Application"

first of all i want to say that this problem is NOT about having selected a a x64 driver for a x86, or viceversa. Its not the odbc32 thing. Yesterday needed to do an emergency format of this crappy windows 10. I did and started to install my…
Fran Montserrat
  • 43
  • 1
  • 7
2
votes
1 answer

Why is my tableadaptor forcing a cast to string on my date column

I have a table with dates, and varying data about that date like so. WKDWKDDATE8 WKDDAYNM WKDAGENO WKDDAYNO WKDDATE6 WEEKNO WEEKRANGE AWEEK 2019-05-15 WEDNESDAY 43580 3 AJ0515 384 05/12 - 05/18 …
highboi
  • 673
  • 7
  • 28
2
votes
1 answer

TableAdapter.Update(DataSet) makes cyrillic letters appear as question marks in dgv

I have an application that consists of a DataGridView and a few buttons to manage it more easily (it is about managing gym subscriptions). I add the row to the DataGridView like this. DataTable dataTable =…
Dobromir Nikolov
  • 31
  • 5
2
votes
5 answers

looping through results using C# and tableadapter

Currently when i press my previous button it only returns results to my text box. I want it to loop through the results. So the first time the button is clicked it will show the first record, looping through. protected void btnPrevious_Click1(object…
PriceCheaperton
  • 5,071
  • 17
  • 52
  • 94
2
votes
1 answer

TableAdapter.Update(dataset) not saving to database in Ado.NET

I have seen the other posts on this subject. Yet so far there has been no solution. I am working with Visual Studio 2013 in C#. I have a database "Database1.mdf" with one table called Customers, which just has two records. I created the DataSet…
Andi Truman
  • 111
  • 1
  • 6
2
votes
1 answer

Why TableAdapter doesn't recognize @parameter

I am using table adapter Query configuration wizard in Visual studio 2013 for getting data from my database. For some queries like this: SELECT * FROM ItemsTable ORDER BY date_of_creation desc, time_of_creation desc OFFSET (@PageNumber - 1) *…
Mohammad Ha
  • 81
  • 2
  • 9
2
votes
3 answers

best t-sql for providing nth page in showing data?

I want to item 1 to 50 in my first page by using SELECT TOP(50) * FROM Items_table and it works fine but how can I get second 50 items for next page? How should be the query be? Please note that I can't use LIMIT because I am using SQL Server. I…
Mohammad Ha
  • 81
  • 2
  • 9
2
votes
2 answers

how to use TableAdapterManager and related datatables in combination with SQL queries

i have a question on how to work properly with related datatables and how to actualize them properly in the backend source database. the situation is following: I have a SQL database (SQL Server) which is the basic data source. In here the tables…
Dave
  • 241
  • 3
  • 14
2
votes
0 answers

Why the performance difference between TableAdapter.Fill data sources

I have a windows form app with a DataGridView populated by a TableAdapter. I'm using the Fill method to update the data for the UI in a looping Async sub like so. Private Async Sub updateUI() Dim sw As New Stopwatch While True Await…
doovers
  • 8,545
  • 10
  • 42
  • 70
2
votes
1 answer

Delete rows from a table without checking that they exist first

I have a WCF service that accepts a DataTable, and merges them into the existing data. Previously, this has just required adding rows, which works beautifully, but with this new requirement of deleting rows (whether or not they actually exist), I'm…
Alex
  • 3,429
  • 4
  • 36
  • 66
2
votes
0 answers

How to correctly update data to local database in C#

I must say - I am struggling with whole Database - Adapter - DataSet model. Using Visual Studio 2010 (C#, .NET, WPF), I have created a local database (.sdf extension). I added data source (Data > Add new data source) from my only table from my…
MkjG
  • 144
  • 2
  • 15
2
votes
1 answer

TableAdapter.Update not working

Here is my function: private void btnSave_Click(object sender, EventArgs e) { wO_FlangeMillBundlesTableAdapter.Update(invClerkDataDataSet.WO_FlangeMillBundles); …
Wesley
  • 659
  • 2
  • 13
  • 19
1 2 3
…
33 34