Dear all,
I need to build a web application which collects data from an SQL server
database.
SQL server database tables fields can be dynamically created or extended
depending on my customer request and can be different customers to customers.
Ideally what I would like to build is a web application frame which covers
any request and display any data. This without rebuilding my application but
more by applying a kind of configuration which will be read from the
application.
Example 1:
Table 1 from Customer 1 contains 5 columns named "Col1" to "Col5"
Customer 1 wants to view on web page all table 1 columns data rows
Example 2
Customer 2 use same table as customer 1 with 2 extra columns named "Col6"
and "Col7"
Customer 2 wants to view on web page all records of "Col6" and "Col 7" only
from table 1
So to sumurize, with different customers application I need to self
configured data which are extracted and view on the page. This without
recompiling the initial project.
How to handle this kind of dynamic view...Do I need to have a separate
configuration file (other than Web.config) on which i could set columns to be
shown ???? (note that I do not know in advance the number of columns and
column names, they are dynamically created by my customer own application)
or any other tips
Is it something possible to dynamically configure the content of the page
view based on customer demand ? if yes how
hope I clearly explain
regards and thanks for your help
Serge 4 1330
try this. Datagrid handle dynamic number of dataset column.
Dim Conn As SqlConnection = New SqlConnection("string connection")
'dynamic query based on user need
Dim Da As SqlDataAdapter = New SqlDataAdapter("Dynamic query", Conn)
Conn.Open()
Dim Ds As DataSet = New DataSet
Da.Fill(Ds)
DataGrid1.DataSource = Ds
DataGrid1.DataBind()
"serge calderara" wrote: Dear all,
I need to build a web application which collects data from an SQL server database. SQL server database tables fields can be dynamically created or extended depending on my customer request and can be different customers to customers.
Ideally what I would like to build is a web application frame which covers any request and display any data. This without rebuilding my application but more by applying a kind of configuration which will be read from the application.
Example 1: Table 1 from Customer 1 contains 5 columns named "Col1" to "Col5" Customer 1 wants to view on web page all table 1 columns data rows
Example 2 Customer 2 use same table as customer 1 with 2 extra columns named "Col6" and "Col7" Customer 2 wants to view on web page all records of "Col6" and "Col 7" only from table 1
So to sumurize, with different customers application I need to self configured data which are extracted and view on the page. This without recompiling the initial project.
How to handle this kind of dynamic view...Do I need to have a separate configuration file (other than Web.config) on which i could set columns to be shown ???? (note that I do not know in advance the number of columns and column names, they are dynamically created by my customer own application)
or any other tips
Is it something possible to dynamically configure the content of the page view based on customer demand ? if yes how
hope I clearly explain regards and thanks for your help
Serge
Thnaks , thats ok for that but what I was meaning by querry is the fact that
display data will be different.
Once again, I will read all datacolumn from the table whatever the customer
is, but then Customer 1 would like to view on the page only first 2 column
for instance and customer 2 only the last one.
How to handle that customer based web page information ?
regards
serge
"netdude" wrote: try this. Datagrid handle dynamic number of dataset column. Dim Conn As SqlConnection = New SqlConnection("string connection") 'dynamic query based on user need Dim Da As SqlDataAdapter = New SqlDataAdapter("Dynamic query", Conn)
Conn.Open() Dim Ds As DataSet = New DataSet
Da.Fill(Ds)
DataGrid1.DataSource = Ds DataGrid1.DataBind()
"serge calderara" wrote:
Dear all,
I need to build a web application which collects data from an SQL server database. SQL server database tables fields can be dynamically created or extended depending on my customer request and can be different customers to customers.
Ideally what I would like to build is a web application frame which covers any request and display any data. This without rebuilding my application but more by applying a kind of configuration which will be read from the application.
Example 1: Table 1 from Customer 1 contains 5 columns named "Col1" to "Col5" Customer 1 wants to view on web page all table 1 columns data rows
Example 2 Customer 2 use same table as customer 1 with 2 extra columns named "Col6" and "Col7" Customer 2 wants to view on web page all records of "Col6" and "Col 7" only from table 1
So to sumurize, with different customers application I need to self configured data which are extracted and view on the page. This without recompiling the initial project.
How to handle this kind of dynamic view...Do I need to have a separate configuration file (other than Web.config) on which i could set columns to be shown ???? (note that I do not know in advance the number of columns and column names, they are dynamically created by my customer own application)
or any other tips
Is it something possible to dynamically configure the content of the page view based on customer demand ? if yes how
hope I clearly explain regards and thanks for your help
Serge
You can show all the column name ( used system table to retrieve the column
name of the specific table from ur database) in a list box. ask the user to
select the column they wish to view. once user select column name
list,create a dynamic query and retrieve the result .
let me know this help.
thanks
"serge calderara" wrote: Thnaks , thats ok for that but what I was meaning by querry is the fact that display data will be different.
Once again, I will read all datacolumn from the table whatever the customer is, but then Customer 1 would like to view on the page only first 2 column for instance and customer 2 only the last one.
How to handle that customer based web page information ?
regards serge
"netdude" wrote:
try this. Datagrid handle dynamic number of dataset column. Dim Conn As SqlConnection = New SqlConnection("string connection") 'dynamic query based on user need Dim Da As SqlDataAdapter = New SqlDataAdapter("Dynamic query", Conn)
Conn.Open() Dim Ds As DataSet = New DataSet
Da.Fill(Ds)
DataGrid1.DataSource = Ds DataGrid1.DataBind()
"serge calderara" wrote:
Dear all,
I need to build a web application which collects data from an SQL server database. SQL server database tables fields can be dynamically created or extended depending on my customer request and can be different customers to customers.
Ideally what I would like to build is a web application frame which covers any request and display any data. This without rebuilding my application but more by applying a kind of configuration which will be read from the application.
Example 1: Table 1 from Customer 1 contains 5 columns named "Col1" to "Col5" Customer 1 wants to view on web page all table 1 columns data rows
Example 2 Customer 2 use same table as customer 1 with 2 extra columns named "Col6" and "Col7" Customer 2 wants to view on web page all records of "Col6" and "Col 7" only from table 1
So to sumurize, with different customers application I need to self configured data which are extracted and view on the page. This without recompiling the initial project.
How to handle this kind of dynamic view...Do I need to have a separate configuration file (other than Web.config) on which i could set columns to be shown ???? (note that I do not know in advance the number of columns and column names, they are dynamically created by my customer own application)
or any other tips
Is it something possible to dynamically configure the content of the page view based on customer demand ? if yes how
hope I clearly explain regards and thanks for your help
Serge
Sounds a solution, I was thinking of that at first but then that will be an
extra round trip to the server....
Then I get an other idea
Would be better if I retrive all data from the table in a dataset, then ask
the user which columns to views and then apply a Datview object based on the
dataset to filter data
"netdude" wrote: You can show all the column name ( used system table to retrieve the column name of the specific table from ur database) in a list box. ask the user to select the column they wish to view. once user select column name list,create a dynamic query and retrieve the result .
let me know this help. thanks
"serge calderara" wrote:
Thnaks , thats ok for that but what I was meaning by querry is the fact that display data will be different.
Once again, I will read all datacolumn from the table whatever the customer is, but then Customer 1 would like to view on the page only first 2 column for instance and customer 2 only the last one.
How to handle that customer based web page information ?
regards serge
"netdude" wrote:
try this. Datagrid handle dynamic number of dataset column. Dim Conn As SqlConnection = New SqlConnection("string connection") 'dynamic query based on user need Dim Da As SqlDataAdapter = New SqlDataAdapter("Dynamic query", Conn)
Conn.Open() Dim Ds As DataSet = New DataSet
Da.Fill(Ds)
DataGrid1.DataSource = Ds DataGrid1.DataBind()
"serge calderara" wrote:
> Dear all, > > I need to build a web application which collects data from an SQL server > database. > SQL server database tables fields can be dynamically created or extended > depending on my customer request and can be different customers to customers. > > Ideally what I would like to build is a web application frame which covers > any request and display any data. This without rebuilding my application but > more by applying a kind of configuration which will be read from the > application. > > Example 1: > Table 1 from Customer 1 contains 5 columns named "Col1" to "Col5" > Customer 1 wants to view on web page all table 1 columns data rows > > Example 2 > Customer 2 use same table as customer 1 with 2 extra columns named "Col6" > and "Col7" > Customer 2 wants to view on web page all records of "Col6" and "Col 7" only > from table 1 > > So to sumurize, with different customers application I need to self > configured data which are extracted and view on the page. This without > recompiling the initial project. > > How to handle this kind of dynamic view...Do I need to have a separate > configuration file (other than Web.config) on which i could set columns to be > shown ???? (note that I do not know in advance the number of columns and > column names, they are dynamically created by my customer own application) > > or any other tips > > Is it something possible to dynamically configure the content of the page > view based on customer demand ? if yes how > > hope I clearly explain > regards and thanks for your help > > Serge This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: GM |
last post by:
Hello...
Please advise me where can I post a message about job seeking for the small
developers team (ASP, XML/XSLT, *script skills)?
Thanks a lot ahead.
Please, advise me to:...
|
by: Varun |
last post by:
Hello
Despite all the advise i have recieved from everyone on this group i still cannot fix this error. I am fast approachin my deadline so i need to fix this asap :o
I get the error whenever i...
|
by: serge calderara |
last post by:
Dear all,
I need to collect different type of data. Source of those data are CSV files
and Access database.
I am thinking on the way I should retrive those data under my VB.NET
application in...
|
by: Jack |
last post by:
I have a asp form where among others there are few text boxes and one check
box. The checkbox is
to indicate whether the entry is final. The checkbox is attahced to a field
in table of type...
|
by: Sergiy Klokov |
last post by:
i need to put a water mark in my pdf... and pdf viewer ocx... not Adobe ...
please advise something
| |
by: Sam |
last post by:
I wonder whether I should install .net framework 1.1 with service pack 1
into MS Windows 2003 Server?
My inquiries
Application using ASP.Net 1.1
- Will it run on MS Windows 2003 Server without...
|
by: Carlos Villaseñor M. |
last post by:
Hi every body:
There are some years that I don´t to practice C++, but since 3 moths when I
decide to take up again "C" I encounter that there are 2 versions of "C"
(C++ and C#), the first time,...
|
by: |
last post by:
Hi Database Gurus,
Not to start a war among fanatics, but I just wanted to get honest opinion/advise of smart folks like you about this. We are about to begin development for a data intensive web...
|
by: David |
last post by:
Hi,
I have taken some SQL from MS Access and got it working.
I have since updated the SQL in Access but cannot get the additional
part working in ASP.
The working SQL I have in asp is:-
...
|
by: jerryst |
last post by:
need help and advise with database...
i am an independant oil and gas consultant and have a fair amount of computer experience but, am lost when it comes to data bases .... i found a database...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |