This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

Create view dynamically from asp.net code, and chose deferent column according to admin selection?

Question
0

Sign in to vote
Hi

I have this project senario:

Admin can select deferant columns from deferent sql server tables and save this selection in some way from asp.net page (form).

This selection can change from another admin, but still have one (saved) selection.

I have some idea to use SQL view, by create view from asp.net code and save it in sql server. Than can alter this view from code!

I don't work with view before and I don't know if this is a god or bad solution?
- Moved by CoolDadTx Wednesday, October 25, 2017 1:44 PM ASP.NET related
Wednesday, October 25, 2017 7:40 AM

All replies

0

Sign in to vote

What you would be saving in a SQL Server table is the XML that defines a dynamic page to be built when the page is dynamically built from the XML that is converted to HTML controls using XSLT.

https://www.codeproject.com/Articles/469723/Rendering-XML-Data-as-HTML-using-XSL-Transformatio

The data that is bound to the control can use a DB view or from a stored procedure.

ASP.NET forms is where you can post for help.

http://forums.asp.net/

Wednesday, October 25, 2017 9:42 AM
0

Sign in to vote

It's asp.net mvc web project.

Wednesday, October 25, 2017 11:15 AM
0

Sign in to vote

It's asp.net mvc web project.
So? The concept works with ASP.NET MVC too of using XML to HTML transformation to build dynamic views.

Wednesday, October 25, 2017 1:07 PM
0

Sign in to vote

Please post questions related to ASP.NET in the ASP.NET forums.
Michael Taylor http://www.michaeltaylorp3.net

Wednesday, October 25, 2017 1:44 PM