Re: Dynamic data display

Question

User503410121 posted

Hello All,

I am using Asp.net with VB.net.

I am trying to create a page to display a table.

There are 4 columns in the table, values of first column will be static, but values of 2nd and 3rd column will be vary for each row depending on the value of first column. Value of 4th column is just the addition of 2nd and 3rd column (thats very easy).

I am just wondering how to go ahead with this, previously I have designed a table just to display the data with a single query.

But in the above case there is separate queries, so any help regarding this would be really really appreciable.

Thank You!!!

Answer 1

User-1818759697 posted

Hi,

According to your description, if you want to Specify Computed Columns in a Table, you could refer to the following information:

A computed column is a virtual column that is not physically stored in the table, unless the column is marked PERSISTED. A computed column expression can use data from other columns to calculate a value for the column to which it belongs. You can specify an expression for a computed column in in SQL Server using SQL Server Management Studio or Transact-SQL.

For more information, you could access to the following links:

http://technet.microsoft.com/en-us/library/ms188300.aspx

http://www.itdeveloperzone.com/2013/04/computed-column-in-sql-server.html

http://blog.sqlauthority.com/2010/08/03/sql-server-computed-column-persisted-and%C2%A0performance/

Besids, if the abvoe information couldn't help, you could describe the issue in detail and post the corresponding code so that we could make further analysis.

Regards

Answer 2

User503410121 posted

Thanks very much for the reply. But I think you didn't get what I asked. My requirement is to display a table with 8 rows.

First col has static values displayed second and third col values will be varied using different queries based on first col static value.

Hope you got it now. It would be really great if you can help regarding this.

Thank you!!!