Stack Overflow
Stack Overflow

Questions tagged [datatableadapters]

38 questions
1
vote
1 answer

VB.Net dataset rows count always returning 0

I created a table adapter for a stored procedure I have, which returns a row from a table. After adding it to the dataset, I try to loop through the row count of this table to retrieve the data but it keeps returning no rows. If I try to preview the…
Eagz
  • 21
  • 4
1
vote
2 answers

What's causing a Concurrency Violation when using a MySQL linked Dataset via TableAdapters?

The more I read on this, the more confused I get, so hope someone can help. I have a complex database setup, which sometimes produces the error on update: "Concurrency violation: the UpdateCommand affected 0 of the expected 1 records" I say…
stigzler
  • 793
  • 2
  • 12
  • 29
1
vote
1 answer

I think my ADO.Net table adapter is incorrectly right padding spaces to results

Im writting a C#, .Net3.5, 3 tier web application with ASP.Net front end, SQL server back-end, interfacing with them via TableAdapters and stored procedures. I've stumbled across some odd functionality. I have a AdminUsers table with columns UserID…
sMaN
  • 3,667
  • 4
  • 23
  • 33
1
vote
1 answer

Visual Studio TableAdapter syntax error on SQL statement

This is getting pretty annoying. This SQL statement runs fine in Access: SELECT payrecords.*, employees.name AS employee FROM Payrecords INNER JOIN employees ON payrecords.employee_id = employees.id WHERE payrecords.payrun_id = ? ORDER BY…
Joe Gillon
  • 107
  • 10
1
vote
2 answers

LINQ to DataSet Dataclass assignment question

I'm working on a Silverlight project trying to access a database using LINQ To DataSet and then sending data over to Silverlight via .ASMX web service. I've defined my DataSet using the Server Explorer tool (dragging and dropping all the different…
Overhed
  • 1,289
  • 1
  • 13
  • 41
1
vote
0 answers

Visual Studio 2012 and the Configuration Wizard for TableAdapter in use with MySQL

I really tried to avoid asking here cause I'm more like the guy who likes to do it on his own, but I came across a point where I'm wasting hours for hours with no results. It's about Visual Studios DataTable Configuration Wizard in combination with…
Creyel
  • 11
  • 2
1
vote
1 answer

Android get image Uri from camera, store in SQLite and restore it on my custom adapter

I followed the Android developers example of get an image form the camera intent and place it on your view. The problem starts when I try to save that image uri on my SqliteDatabase ( just the link to that image not the full image so I save space)…
Nonyck
  • 652
  • 1
  • 12
  • 28
0
votes
0 answers

Connect Azure Postgresql database in sailsjs

I'm trying to connect my azure postgresql database to my sails app, using sails-postgresql adapter my connection url is this url:'postgresql://@:@.postgres.database.azure.com:5432/', postgresql…
Dileepa Mabulage
  • 1
  • 2
0
votes
2 answers

save new record entered from Datagridview into the database

Am using a DataSet and a TableAdapter to populate a Datagridview. The Datagridview allows inserting new records at the bottom. Now when I enter values for the new record in the Datagridview, the record is not automatically saved back to the…
Gonzalez
  • 3
  • 1
  • 2
0
votes
1 answer

Quality of the autogenerated sql queries in Visual Studio

I was having an issue with the auto generated delete statement. In my mind the delete should have just been DELETE [tablename] where [PK] = @param but instead it generates a query with 4 ORs. DELETE FROM Market WHERE (@IsNull_Name = 1) AND…
Mesh
  • 6,262
  • 5
  • 34
  • 53
0
votes
1 answer

VB.NET TableAdapter not defined

I'm sure this must be an easy fix, but I haven't been able to see my error. This code worked previously. I'm currently using VS 2019. I'm receiving an error that my tableadapter is not defined. Dim mbtAdapter As New…
Dionna
  • 1
  • 1
0
votes
1 answer

IBM Db2 Visual Studio 2010 Table Adapter Problem

I am using db2 database on my localhost and I want to use TableAdapter in my web project. When I connect the database with server explorer the table names doesn't shown. I checked the privileges of the user and give them full access. The db2admin…
Mesut Basaran
  • 1
  • 1
0
votes
0 answers

Display data from one to many relation using ASP.NET Web Forms data controls

I have a relation consisting of ProjectsOverall to Projects. ProjectOverall contains many Projects and a Project is assigned exactly to one ProjectOverall. One having the detail view a ProjectOverall I want to display all it's Projects. This leaves…
Peter
  • 1,844
  • 2
  • 31
  • 55
0
votes
0 answers

Generate code file from data table adapter

I'm working on an older web site application in C#, ASP.NET, which is now running on 4.7.2 The WebControlling.xsd contains the definitions, constraints and operations on the dataset with tables and table adapters. For all the older tables there is a…
Peter
  • 1,844
  • 2
  • 31
  • 55
0
votes
0 answers

UpdateAll fails for tableset

I have a windows forms project that is working well except for the save button that was created by the designer. The last statement in the save item click event fails. This code was generated by the designer and I don't totally understand it. Does…
Jerry Welliver
  • 377
  • 1
  • 13
1
2 3