Getting schema for database
Hey all, long time no talk. Busy with school and and work. Have a question for you. I actually worked around doing this but would like to know how to do it.
Suppose I want to make a web app that works with a SQL database disconnected through datasets or datatables. I want to use datasets to upload my changes. How do I pull down the schema or prepare a dataset for my entries into a database table on the SQL server that has already been made.
I believe I am wanting to pull down the schema into a dataset so I can have a template to bind to and start adding to to update. Only way I get around this is to build a collection and store my data there and then put it in a foreach loop updating the database after I am ready to upload all my updates or I build the dataset by hand. I just want ot be able to build the dataset from the schema that is on the server though dynamically. Hope I made sense.