TableAdapter Update - C# / C Sharp

RobZ via DotNetMonster.com

Hi all,
I am using a tableadapter to read data from a table - no problem,

I have configured the Tableadapter to add an InsertQuery.

My problem is when I first Call the InsertQuery and then re-load the data (
into a list ) the new row does not appear, however if I re-call the
InsertQuery again (but this time with different data) the first inserted
Row now appears, this continues, each Time the InsertQuery gets called it
adds the PREVIOUS Data, (Even if I shut the app down & restart)

Somehow the row IS being added, I just can't seem to read the new Row until
another insert has happened.

I read the data with tableAdapter.GetRows().Select()

I have tried to use the update method but I can't get it to work.

any Ideas?

--
Message posted via http://www.dotnetmonster.com

Nov 17 '05 #1

Subscribe Reply

6440

RobZ via DotNetMonster.com

Sorry, I must be getting Old,
Table WAS being updated, If you don't display the last record from a
recordset, it shows the above behaviour :(
Mind for Sale, (only slightly used)

--
Message posted via http://www.dotnetmonster.com

Nov 17 '05 #2

Similar topics

7189

ADO.NET 2.0 TableAdapter Configuration Wizard

by: Mike | last post by:

Dear Group, When I add a DataTable to a Typed Dataset, and a TableAdapter to the DataTable, I am able to create methods to send updates directly to the database (GenerateDBDirectMethods),...

Visual Basic .NET

2526

Problème data tramsmission from tableadapter to ACCESS database

by: philip | last post by:

On a form, I have a datagridview. This datagridview is constructed on a dataset filled by a tableadapter. The table adapter do very well what it must do when filling dataset. Insertions,...

Visual Basic .NET

1834

tableadapter update - sql server 2005 raiseerror datatables

by: vbnetguy | last post by:

Hopefully someone has an answer for this or maybe I am missing something. I have a stored procedure - this stored procedure is used as my main insert for a tableadapter I am doing something...

Visual Basic .NET

1745

TableAdapter Problem

by: GaryDean | last post by:

I'm comparing use of DataView -ObjectDataSource -TableAdapter to DataView -SqlDataSource using the Customers table on the NorthWind database. The SQL given to both wizards is: SELECT ...

ASP.NET

1701

TableAdapter, Insert, and Datatype

by: Yin99 | last post by:

I'm using TableAdapter with .NET 2.0 and SQL 2005. In SQL Database, a column's type is "float". Default TableAdapter methods update, insert, get, etc. maps this automatically to c# type...

ASP.NET

1202

tableadapter update problem

by: arevans | last post by:

I can't seem to update the data source when I call the tableadapter's update method. Here is my code: DealsTableAdapter ta = new DealsTableAdapter(); dsDeals.DealsDataTable dt = new...

.NET Framework

3902

Need to wait for TableAdapter.Update to finish

by: Boris227 | last post by:

I have written an application that has a DataGridView for users to amend a table. When finished they click a 'Save' button, which generates a series of queries based on the new data. The problem...

Visual Basic .NET

2257

foreign key update in Tableadapter dataset

by: Sreekanth | last post by:

I have a dataset with TableAdapter A and TableAdapter B. B has a foreign key which refer backs to A. I add a row to table A and then add several rows to Table B. I update ID of table A of table...

.NET Framework

2184

Issues w/ using a DataTable with a TableAdapter's Update method

by: Craig Buchanan | last post by:

I created a TableAdapter (TA) in my VB 2005 project. I tested it to ensure that its CRUD functionality is what I expected it to be. I'm using the TA and its strongly-typed DataTable (DT) in my...

Visual Basic .NET

7234

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7344

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7069

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

7505

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5652

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4730

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

1570

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

775

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

441

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General