Wednesday, August 18, 2010

How to dynamically generate a dataset?

I have 4 columns in a database and i want to generate a dataset dynamically with fifth column which is an ouput based on calculations done on the values of the rest of the columns. I want to generate a datagrid based on this dataset.How to dynamically generate a dataset?
Let a, b , c ,d be the database fields then you can write a db query like this


select a,b,c,d,((a+b+c)/d) from tablename





You can use any arithmetic operations like the above along with the Query and fill the data set using this sort of queryHow to dynamically generate a dataset?
you need to run a query - these performs actions on the data - running the query will generate the data for the extra column -
  • love myspace
  • myspace girl
  • No comments:

    Post a Comment