tableadapter

  1. D

    Question Stored Procedure/TableAdapter and Failed to enable contraints

    I have been struggling for several days now trying to figure out why I am getting the failed to enable constraints, one or more rows contain values violating non-null, unique, or foreign-key constraints when running my code. I have a stored procedure in sql server, part of it below...
  2. D

    Question VS2013 Table Adapter Syntax Error: Expecting identifier or quoted identifier

    If I am posting this is the wrong area, I apologize. I am trying to add a table adapter to one of my datasets. The dataset has oracle as its datasource using ODP.NET. When I put in the query (which works elsewhere) I get this error (Syntax Error: Expecting identifier or quoted identifier)...
  3. I

    Question TableAdapter, Add works, Update works, Delete has no effect

    Don't know what's happened to my post?... Hi All, I've been banging my head against this for days now if anyone can help it would be greatly appreciated I've got a couple of forms that share a datatable (declared in a module as public), it's basically a list of documents, one form has a...
  4. R

    Development strategy with VS Designer and Datasets

    I've programmed in various languages but am just getting started with VB Net under VS2010 Express and SQL CE 3.5. It's pretty cool how you can drag-and-drop from a Dataset and create forms that display parent records and their synchronized child records with no programming at all. But I've run...
  5. E

    Update Data from data set and table adapter

    I have a windows form program that pulls data from a sql server. That same data is being read from a ASP.NET website that sets properties for the site. The SQL server has 3 tables: tblWebPage, tblObjects, tblProperties. and 6 views for the 6 web page: vWebPage01, vWebPage02, vWebPage03..ect...
  6. Th4x3

    Question Data TableAdapter

    He im creating a user login form where my users put in a nickname and the TableAdapter searches for the matching password and returns it to my program, I made a little code to convert the tabulardata to an single string but when i use it i get a blank msgbox where the password should be...
  7. Th4x3

    Question Sql Table Adapter

    He im creating a user login form where my users put in a nickname and the TableAdapter searches for the matching password and returns it to my program, I made a little code to convert the tabulardata to an single string but when i use it i get a blank msgbox where the password should be...
  8. PatelNehal4u

    Question Confusion in TableAdapter Configuration Wizard?

    Hello Everyone, I am new to ADO.net and still learning vb.net. Right now i am learning ado.net and use of it with windows forms. But now i am confused with one method in tableadapter configuration wizard, which is created at second last step of wizard. In wizard it create two methods : 1. Fill...
  9. I

    Write to table

    I am feeling stupid, which doesn't take much these days. I have a simple program in vb 2005 that generates data. I have created a table in which to store the date (3 columns, 4 if you include the index). So when I run my program, how do I get the data in the table? I have literally spent...
  10. I

    Yet Another TableAdapter.Update that doesn't work

    Hi List, I created a typed dataset by dragging the table from Server Explorer onto my dataset designer. The TableAdapter.Fill and FillByXXX methods (that I created) work perfectly, but the Update method always returns 0. I placed the following code just before the Update method call just to...
Top Bottom