Questions tagged [datatableadapters]
38 questions
0
votes
1 answer
Show specific row on a bound form
I have a form that is bound directly with a table adapter created with the designer. I also created a list box with the key value from each record. My thought is to allow the user to click on a specific key to load the desired record in the edit…

Jerry Welliver
- 377
- 1
- 13
0
votes
2 answers
Change SelectCommand on runtime
I've created on my dataset a tableadapter with the next select command
select count(*) as cuenta from table1.
But, on the runtime, I need to compose different selects with variable number of clauses. I'd like to use the same tableadapter but I'm…

davidrgh
- 853
- 2
- 10
- 17
0
votes
1 answer
MVVM, using Multiple DataSets and Multiple ComboBoxes tied to each other
I have a single Database EstimateInformationTable with CATEGORY, DESCRIPTION. 100 records total. There are 100 Descriptions and 10 Categories, so obviously the Categories are used more than once.
example:
+----------+-------------+
| CATEGORY |…

mjordan
- 319
- 2
- 22
0
votes
1 answer
Bind Dynamic JSON Object to Kendo Grid
I have a JSON object returned from a DataSet as below.
I use a DataSet rather than EF Model as the SQL query returns dynamic data. So the columns could be anything any time the query is called.
{
"Table": [
{
"Entity": "SP00",
…

Kevin
- 241
- 6
- 21
0
votes
1 answer
Unable to load image from Firebase Database using an URL with Picasso
I am trying to Inflate a ListView with images stored on http://cloudinary.com/. The URL of the image is saved as a field in my Firebase Database. I am Using Picasso Client for the same. But What I notice in my database is that URL Link stored for…

Sumeet Shah
- 5
- 4
0
votes
1 answer
how to add static method in TableAdapter
i'm working with .net 2 and visual studio 2005
I want to know how to add/create a static method in a TabelAdapter
thanks

Eatdoku
- 6,569
- 13
- 63
- 98
0
votes
1 answer
XSD Files in asp.net preview data
I have created a Stored Procedure in SQL and have configured it to be used with DataTables. The stored Procedure accepts 3 variables.
1. 3635 (Int)
2. NotMeeting (AnsiString)
3. 1 (Boolean)
When i want to preview the output after inserting values…

user532104
- 1,373
- 6
- 17
- 27
0
votes
1 answer
Displaying specific Data from SQL Database without a Column to filter by. (VB.NET)
I have a DataGridView which is displaying Data from dbo.tblAttendanceTimes using tblAttendanceTimesTableAdapter.GetDataBy(intEmployee)
So obviously it will display all the Data for the selected Employee.
The Employees are split in to 3 groups. What…

Pete
- 469
- 7
- 18
0
votes
2 answers
C# Winforms DataTableAdapter databindinding question
I have an app written in c#.
Records from the DB are shown through the auto-generated visual studio code (DataTableAdapter).
this._______tTableAdapter.Fill(this._______SQLDataSet._______);
Now, when I make changes to the DB, not through the…

Andrej
- 351
- 2
- 6
- 12
0
votes
1 answer
ADO.Net Get Inserted Row's ROW ID without designer wizard
I have a generic update function that takes a datatable, select query and uses this to update the database tables.It is working fine. I need to know is there a way to get back the inserted row's ID (identity field) by changing something in the below…

chiku coder
- 11
- 3
0
votes
0 answers
Get The Properties From A Dataset Query
I have a dataset - ImageDataSet.xsd - that has a datatable in it - Colour - with it's relating tableadapter - ColourTableAdapter -. This ColourTableAdapter has a custom query added to it - FillByColourID - that is linked to the database stored…

Metal Paw
- 112
- 1
- 13
0
votes
1 answer
Strongly typed DataSets and dBase IV on OleDb
I have a strange problem. I created a strongly typed DataSet and wanted to add a TableAdapter. I did the following steps:
Add TableAdapter
New Connection
2.1. Set the DataSource to .NET Framework-dataprovider for OLE DB
2.2. OLE DB-Provider:…

Marcel Grüger
- 885
- 1
- 9
- 25
0
votes
1 answer
Insert Query into postgresql using Table Adapter C#
I am trying to insert data into a postgresql table in visual studio windows forms table adapter using this query;
INSERT INTO PUBLIC .cashaccount
VALUES (:cashmemo, :cashcredit, :cashdebit)
I am using the ':' because I am aware the '@' operator…

Robert Omete
- 64
- 1
- 10
0
votes
0 answers
The type name 'UserDetailsDataRow' doesn't exist in the type 'UserDetails'
I am new to C# and currently using VS2010. When I try to do this:
UserDetailsTableAdapters.UserDetailsTableAdapter userDetails = new UserDetailsTableAdapters.UserDetailsTableAdapter();
UserDetails.UserDetailsDataTable loginDetailsTable =…

Phantomazi
- 408
- 6
- 22
0
votes
1 answer
ADO.NET TableAdapter Updating on CellValueChanged Event for a DataGridView
I have a DataGridView which includes a checkbox column for a Boolean variable in the database.
When I click on this checkbox, it fires the events below.
Inside the uiPersonGridView_CellValueChanged event, I call the Data Table Adapter Update method…

SamoanProgrammer
- 954
- 4
- 13
- 27