a .Net component, that fills a dataset with data from the database.
TableAdapter is a .net component, that fills a dataset with data from the database.
Questions tagged [tableadapter]
505 questions
-1
votes
1 answer
EPPlus Not Filling Excel File
I am exporting a data table to Excel using EPPlus but I keep getting no results. I get a worksheet with headers and a label on the tab but no data. I verified that the tableadapter has data in it.
Here is my code:
FileInfo newFile = new…
Missy
- 1,286
- 23
- 52
-1
votes
1 answer
Filling datasets by using Tableadapters is not working
I have to develop project using Tableadopter. Actually worked but when I change SQL Server password is not working. So my project totally corrupted also my final year project submitting date on June 10.Suddenly I struggled this Please help me....…
Meena S
- 27
- 1
- 10
-1
votes
1 answer
VB.NET tabledapter query insert into from another dataset
I have a situation where I want to Insert into access DB table from MS SQL table.
Same columns and everything.
I have both data sets and both table adapter. I can do what ever I want inside each dataset - any manipulation but I cannot insert from…
DAMS
- 1
- 1
- 4
-1
votes
2 answers
C# DataSet Namespace
So I've seen similar questions asked regarding this but none of the answers ever solved my issue. So I'm going to ask for myself.
I have a web application written in C# with VS2010. The website runs perfect uncompiled. When I attempt to build the…
PigsIncorporated
- 143
- 4
- 18
-1
votes
1 answer
after datatable merge, the tableadapter.update method returns 0
I have tried so many ways to get my database to update my added rows but with no luck. This is what I have:
2x databases (local and remote)
2x data tables in their own datasets
the local database has 3 extra columns (1 nchar(15) and 2 bit all…
Steven de Beer
- 108
- 1
- 14
-1
votes
2 answers
how to update database from datagridview
I've checked the option Enable Editing in the datagridview
I've a dataset model generated from my database i'm trying to use update method but its not taking the right parameters
on load even it is fetching and showing into datagridview.
…
Shaikh Noman Nasir
- 29
- 1
- 10
-1
votes
1 answer
optimize SQL select in tableadapter fill method
I have used following query to fill my table adapter but when my application run it is so slow ,but when I run in sql management its fast! let me know the problem of my select and how could be more optimized !!!
SELECT (
SELECT FullName AS…
franchesco totti
- 582
- 1
- 7
- 28
-2
votes
1 answer
Error when click on Add in RadGrid: Failed to enable constraints. 1 or more rows contain values violating constraints
There were many similar questions in StackOverFlow but none gave an answer..
when I click on "Add New" button of RadGrid, I get below error:
Failed to enable constraints. One or more rows contain values
violating non-null, unique, or foreign-key…
timz_123
- 435
- 1
- 9
- 47
-2
votes
2 answers
Error in WHERE clause near '@'. Unable to parse query text C#
I am trying to add a parameter to my table adapter in my C# project. When I add the @ to the where clause visual studio gives me an error. Here is my SQL statement:
select PO.PO_Num,
PO.Supplier,
PO.DateOrdered,
PO.DateRequired,
PO.Terms,
…
nate
- 1,418
- 5
- 34
- 73
-2
votes
1 answer
Editing Stored Procedure and Updating table Adapter
I just updated the stored procedure by adding one more column then i went to table adapters and recreate the table adapter but the updated column wont appear in data columns.. How can i fix this issue? Please Help...
TAB
- 57
- 4
- 16