Pick Database field from asp.net page and save them
Ok here is what I am trying to accomplish, I have a table with lots of fields for registration of different products. Each time they add a new product they want to be able to save the fields that they want to fill out in a db so that I do not have to hard code them each time with code. So how can users pick which DB fields they want to save information agianst and save in table so that when they go to the page it pulls up only the fields that they picked to fill out?
So they add a product called WIFI
WIFI has the following properties that they want to capture
IP,
dataplan,
range
carrier
so they pick these fields from the registration table and save to antoher table that keeps the fields they picked so when they open the page it only shows the fields they picked.
IS this doable and can someone give me some guidlines on how to do and I can figure out most from there.
So they add a product called WIFI
WIFI has the following properties that they want to capture
IP,
dataplan,
range
carrier
so they pick these fields from the registration table and save to antoher table that keeps the fields they picked so when they open the page it only shows the fields they picked.
IS this doable and can someone give me some guidlines on how to do and I can figure out most from there.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,
The database is already predetermined based of off the characteristics of IT products, so when they insert a new IT Product they pick and save the fields from the DB they plan on using, so that it pops up on the page each time they go to it. Then they can save the data and move on.
So it sounds like I can query the schema of a table and from here they will need to save which ones they pick into another db as the chosen fields from which the page will load these fields and tehn save the data to the table.
The database is already predetermined based of off the characteristics of IT products, so when they insert a new IT Product they pick and save the fields from the DB they plan on using, so that it pops up on the page each time they go to it. Then they can save the data and move on.
So it sounds like I can query the schema of a table and from here they will need to save which ones they pick into another db as the chosen fields from which the page will load these fields and tehn save the data to the table.
ASKER
Ok,
Just so I am on right track, I found out how to query the table Schema, now I need to pick the columns I want, and then save these columns in another DB with the product and its accompany fields names from which I will query to put textboxes on the asp page which allows them to save the data. Right track or wrong.
Just so I am on right track, I found out how to query the table Schema, now I need to pick the columns I want, and then save these columns in another DB with the product and its accompany fields names from which I will query to put textboxes on the asp page which allows them to save the data. Right track or wrong.
Sounds like you are on track for the approach suggested by gery128. It's certainly a good way to approach the problem.
ASKER
Thanks for the good start, i have it all selecting and saving in a table. Next the harder part.
On the other hand, my approach treats the extra columns as data, so you can add columns without refactoring the database structure when you want to add a new product with different features that need to be listed.