Visual Web Developer 2005 data table adapter walkthrough?
I am attempting to learn how to use SQL Express 2005 as a back end for web apps in Web Dev 2005, but am running in to a few problems. I have created a database, and using the wizard have created a dataset for my project. However I am unable to use the table adapter that is created in any code. Is there a walkthrough for filling a DataTable? I have seen several tutorials that show how to bind this data to a control, but this is not really what I need.
Thanks for any suggestions,
Michael
Did you notice that the table adapters live in a different namespace? For example if you have a DataSet MyDataSet then your TableAdapters will be referenced with:
MyDataSetTableAdapters.MyTableTableAdapter (assume the you have a table called MyTable.)
This is because MyDataSetTableAdapters is the name of the NameSpace VS created to house your TableAdapters.
As I recall VS will add a call to the Fill method of your TableAdapter in the method responding to the Form.Load event of your Form when you drag a DataSource onto the designer surface.
hth,
-Michael