Last post Aug 15, 2013 11:31 PM by andhaman
Aug 13, 2013 11:48 PM|andhaman|LINK
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.
Aug 15, 2013 11:24 PM|Shawn - MSFT|LINK
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:
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.
Aug 15, 2013 11:31 PM|andhaman|LINK
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.