Newbie here! I am creating a Budgeting app for my boss to use in our IT Department. Currently, it is a simple Access database with a few tables, forms, and reports. I have imported the data into sql and am working on making a web interface for entering all of our purchases/budget information. I am trying to figure out the best way to get 5 sql tables into a dataset, along with specifying relationships.
Can I use the fillschema method on a data adaper for more than one table? In other words, can I do something like this:
da.FillSchema(ds, SchemaType.Source, "Vendors")
da.FillSchema(ds, SchemaType.Source, "Invoices")
Also, I have a number of features I want to be able to do in my web app. For instance, I want the user to be able to "add a vendor" and "add an invoice". Should I create separate webpages for vendors and invoices or should I have one main page that gets changed dynamically depending on which feature the user clicks on?
I hope I have explained myself clearly! Thanks!