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
0
votes
1 answer
Dynamically Instantiate a Table Adaper Created with a Dataset Generator
I have a number of stored procedures. I used the .net server explorer and the dataset generator to create table adapter and table pairs.
Now in my code I want to dynamically instantiate these table adapters based on the user selecting a choice from…
agezna
- 133
- 1
- 3
- 9
0
votes
1 answer
How to check for Null on 2 different datasets and not output null tables
I have a program that auto launches with Windows via scheduler. What it does is runs a query and then emails the results of the query. This all works. We have 10 locations so I will be editing this so it sends 5 different emails... The problem…
Shmewnix
- 1,553
- 10
- 32
- 66
0
votes
1 answer
How to email multiple queries to multiple users
I have a program that auto launches with Windows via scheduler. What it does is runs a query and then emails the results of the query. This all works. What i'd like to do is take the program to the next level. We have 10 locations. The location…
Shmewnix
- 1,553
- 10
- 32
- 66
0
votes
4 answers
3 Tier Architecture c#.
I having problems with my 3 tier architecture. It seems that I could not count the number of players due to implicit conversion from object to Int.
DropDownList
protected void ddlManufacturer_SelectedIndexChanged(object sender, EventArgs e)
{
…
Challenger
- 251
- 2
- 13
0
votes
1 answer
how can i get the values that are about to be sent to the database by the TableAdapter through the datagridview?
I'm entering sales entries using a TabaleAdapter and a dataGridView. When a row is about to be saved, i want to check the StockBalance of the selected product and verify that current stock for selected product is not less than amount being sold. if…
StackTrace
- 9,190
- 36
- 114
- 202
0
votes
1 answer
How to read errors from database when using TableAdapter?
I am using TableAdapter, but I cannot capture any errors that comes from SQL. Here is a piece of my code:
errorText = "";
DataTable AddFilesResult = new DataTable();
var dockDataAdapter = new…
Karolis
- 43
- 1
- 7
0
votes
1 answer
Intercept and change SQL on TableAdapter
We have a Dataset with about 40 TableAdapters on it. These are used everywhere in several hundred differnt projects.
To add a layer of security I now have the requirement to add some paramaters to all the queries on all the TableAdapters in the…
TheRealTy
- 2,409
- 3
- 22
- 32
0
votes
2 answers
TableAdapter is returning phantom results in ASP.NET
I have a TableAdapter that is fetching rows from a stored procedure. For some reason, when there are no results, the TableAdapter returns an INT with value 0 instead of NULL. The stored procedure has NOCOUNT ON.
The problem with this is that I have…
Donnie Thomas
- 3,888
- 8
- 47
- 70
0
votes
1 answer
How to get Dataset table to generate the insert statment .(sql ce3.5 and Dataset with visual studio 2010 express )
I was able to generate update statments excep the insert statement for the file query for a dataset for ce 3.5 database table on a c# visual studio 2010 express project with sql ce 3.5.
However I got run time error:
Update requires a valid…
ggAv115
- 1
0
votes
1 answer
Does SQL Server 2005 Automatically Convert Time Fields to UTC? Does ADO.Net?
I'm using Visual Studio 2008. I'm using an .xsd/tableadapters to access a SQL Server 2005 database. One of my tables has a DateTime field. When a record is inserted into the table, the time is automatically converted to the UTC time, which is fine.…
Brian
- 334
- 4
- 16
0
votes
1 answer
Select a tableadapter at runtime
Suppose there are n buttons and one datagridview.
I drag a dataset which contains n tables, therefore create n tableadapters that has the same connection string. I want to click each button to display each table in each tableadapter respectively.
I…
user1108948
0
votes
1 answer
override the connection in table adapters - UpdateCommandConnection Method
I need to override the connection in my new table adapters, as they are currently using the connection strings used during development. (VS2008).
For instance, using an existing table adapter Orders as an example, the connection string gets…
Fetchez la vache
- 4,940
- 4
- 36
- 55
-1
votes
1 answer
DataGridView - Search and Load by multiple columns and only 1 Search button
For example I have a Table with 2 columns:
Person Age
Person Name
Right now, in the Query screen, I have 2 textboxes and 2 different search buttons:
Textbox 1: SearchByAge
Textbox 2: SearchbyName
I have a different code for each Search…
Tony Stefan
- 1
- 1
-1
votes
2 answers
How to use Where clause with DataSet in C# Win form
I use adgv (advanced filter) to my dataGridView with DataBindingSource
computerDataSet is my Dataset
computerBindingSource is my BindingSourse
and computerTableAdapter is my TableAdapter
In my Load form it creats this one to load data from my…
Anna
- 69
- 1
- 10
-1
votes
1 answer
C# Updating Dataset and DataGridView
So im trying to have a DataGridView that is connected to a database, with some text boxes and a button to add more data to the DB. I can have it update the table, but cant get it to properly update the Database.
using System;
using…
K.Denn
- 13
- 4