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…
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…
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:…
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