generate one dataset from another dataset

Question

1.00/5 (3 votes)

See more:

i have table named Tbl_Product

Tbl_Product
pid (int)
pname (varchar)
price (int)
Stime (datetime)
Ctime (datetime)

i fill dataset from this table using,

HTML

SqlConnection con=new SqlConnection(Conn String);

Dataset ds=new Dataset();
con.open();
SqlDatAdapter adp=new SqlDatAdapter("select * from Tbl_Product",con);
adp.fill(ds);
con.close()

now my dataset ds consist
pid,pname,price,Stime,Ctime

but i want to generate another dataset which consist

pid, pname,price,(SystemDatetime-Ctime)

another dataset i want to generate because i want to load first dataset at one time at pageLoad
but i want to reload another dataset based on system time
i want to reload each and every second using updatepanel timer.....

so...how can i generate
thanks

Posted 8-Apr-12 19:27pm

PKriyshnA

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Reza Ahmadi · Answer 1 · 2012-04-08T20:17:00

Hi,
In order to do that you can use Linq to DataSet. Take a look at this sample:

C#

DataTable t1 = new DataTable();
           t1.Columns.Add("key1");
           t1.Columns.Add("c1");
           t1.PrimaryKey = new[] { t1.Columns["key1"] };
           t1.Rows.Add(1, "data1");

C#

var t3 = t1.AsEnumerable();
          var t4 = t3.Select(rec => new
          {
              key1 = rec["key1"],
              c1 = rec["c1"],
              Time = DateTime.Now.ToString() + rec["c1"].ToString(),
          }).ToList();

using above code you can query a pre defined DataTable and add or remove new columns to the newly generated DataTable.

I hope it helps,
Cheers.

Nilesh Patil Kolhapur · Answer 2 · 2012-04-08T20:27:00

Solution 2

hi,
if u want fill dataset at regular interval then write web service and call it. in this web service write code to fetch data from database and fill it in dataset.
if any problem give reply

Best Luck

Posted 8-Apr-12 20:27pm

Nilesh Patil Kolhapur

Comments

PKriyshnA 9-Apr-12 2:39am

i did usig your logic but i want to reduce my load
using webservice all time webservice connect to database
but in database Ctime is static ....
'so how can i fetch it continuously
i also got directly SystemTime-Ctime
but each and every second i need to execute.....so each and every time connect to database
it takes tooo much load and did not get accurate result....
i get data ay onetime on pageload then not need to execute ...
only dataset to another dataset i need to generate ......so....
tnx for your valuable reply