Your advices about creating web application from database arbitrary structure

I want to create web application. I use SqlServer 2008 and asp.net (framework 3.5 sp1). In my task, user can开发者_运维百科 create database arbitrary structure. and i must write system that generate web site by template. is it possible?

It's certainly possible... but not trivial. You have to first create a database structure to hold the "metadata" about the user-generated table. Then you can write a routine that converts the metadata to an actual table structure. Your application can then have a standard search/add/edit/delete screen that reads the table structure and dynamically renders the columns on the page.

If you want your user to create a relational database (multi-table), then you are in for a great deal of pain... the metadata will get much more complex, and the editing screens will become much harder to manage.

Frankly, this is a good reason to check out Salesforce.com

RO