Corrupted TableAdapter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this a Data Set.
In that data set I have three table adapters, each has there own queries.

For some unknown reason, after I added two new fields to the database and
mofified the store procedure to retrieve the new fields, in addition too the
other fields it already retrieves, and finally modified the tableadapter
"GetAssetsById" to retrieve the new fields the TableAdapter Wizard insists on
putting a "GetData" as a Return a DataTable Method even though I have uncheck
the box. Now my applications fails to execute. I am getting errors everywhere
that uses this tableadapter.

Sorry I tried but could not supply the code for the tableadapter.
 
I finally resolved the issue by writing my own data object. The TableAdapter
wizard is buggy.

Now I need to know how to use stored procedures instead of SQL in the object
 
Can you post some of the actual error messages that you receive?

If you plan on using Tableadapters more often in the future (they have
their place), make it easy on yourself when you have to update your SQL
tables:

1) In SQL, Add/Remove the columns from your SQL table
2) In VS, right click on the datatable and select "Configure.." to let
you walk through the TA wizard. In there, you merely add the new
columns (or remove old ones), and VS will do the rest of the editing
for you.
 
I can't post any error messages.
Yes Tables adapters are very useful. That is why I created my own.
Thanks for your response.
 
Back
Top