Questions tagged [datatableadapters]
38 questions
0
votes
0 answers
Unhandled exception with tableadapter insert inside for statement
I use visual studio 2013 to create a winform app with tabaleadapter to connect with database. My problem is insert query throw a unhandled exception when it inside a loop statement.
This code work:
abcTableAdapter.InsertQuery(param1, param2,…
Nghi Ho
- 463
- 1
- 6
- 18
0
votes
1 answer
XAML DataGrid update doesn't update database
I am trying to update database records from XAML DataGrid on RowEditEnding event
DB name: ManageOrders
Table: Customer: ID (Guid), Name (varchar), Address (varchar)
Database set as : copy if newer
Dataset set as : Do not copy
If i hard code my…
Yuki
- 43
- 1
- 11
0
votes
1 answer
C# - How to filter ComboBox2 data by ValueMember of ComboBox1 using DataSet
I have a Windows Form with two comboBoxes, each one is populated using a DataSet and a TableAdapter. ComboBox1 contains Employee's names and ComboBox2 contains the territories assigned to all employees. I would like to be able to select an…
Javier Maldonado
- 3
- 3
0
votes
1 answer
Database not inserting rows through dataset and tableAdapter Vb .Net
I'm trying to insert a new row into students table but its not doing anything.
Heres my code:
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim stAdapter As New…
Inaloz_H
- 41
- 2
- 9
0
votes
1 answer
Resizing column size of a table in DB and effecting with the dataTableAdapter on a Dataset.xsd
I'm asking about a problem with C# and Visual Studio 2012; I'm trying to resize a column of a table in my database, effect with the dataTableAdapter on a Dataset.xsd
I'm using DataTableAdapter from a stored procedure with a SELECT statement to…
Shammie
- 131
- 1
- 7
0
votes
0 answers
No overload for method 'GetData' takes 0 arguments
i am trying to link two form together, and have created a stored proc and added to the .xsd, but im getting this error for the siaoTA.getData();
i have done this for other forms and had no issue, i cant think what im missing. does anyone know what…
0
votes
1 answer
VB.Net insert to access database
I've just started with VB and have become stuck trying to insert data as a new entry in an access database table... I know my SQL is correct but I don't understand how to use the TableAdapter update function
I have…
Matt
- 343
- 2
- 4
- 17
0
votes
1 answer
SqlDataAdapter not firing RowUpdated or RowUpdating during successful Insert
I have the following code:
DataSet dataSet = new DataSet();
bool result;
using (SqlConnection connection = new SqlConnection(command.Connection.ConnectionString))
{
connection.Open(); …
Toret
- 91
- 1
- 14