about dataset in windows application

Question

0.00/5 (No votes)

See more:

I retrieve some data from database and keep it in a dataset. After some day I want to check that this data in dataset is updated or not. How I check it?

Posted 30-Jul-13 0:03am

davi_p

Add a Solution

Comments

Naz_Firdouse 30-Jul-13 6:13am

please explain in detail

davi_p 30-Jul-13 6:32am

I retrieve some data from database and keep it in a dataset. After some day I want to check that which data I retrieved from database is same as before stored in dataset currently now.
I want how I check that dataset data is updated or not updated.
Am I clear?

Sadique KT 30-Jul-13 6:58am

Once You close your application ..you will lose the data in dataset..
Better you keep your table data in a temporary table in database itself. and compare it with original..

Rajan from Thiruvananthapuram 30-Jul-13 6:20am

Dataset is a collection of data tabel in database

Manikandan Sekar 30-Jul-13 7:00am

What is your need tell correctly, then only others can help you.

davi_p 31-Jul-13 8:01am

I just got an interview in CMM Level5 last week.They just ask me this question for Windows application.I worked in Windows application nearly 2 years but I never do this type of things...That keeping some data in dataset and then checking sometime after that dataset data is updated or not. How I check that dataset data is updated or not.This site help me a lot in VB.Net and C#.So I want to know this question.I also do not understand the question so I ask you here....I know you people are expert and can help me.

Manikandan Sekar 31-Jul-13 9:34am

Ok no problem davi_p i am just asking your need clearly, so that i can help you. ok lets take a look on the links i posted, did you got any idea on that.

1 solution

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)

Manikandan Sekar · Answer 1 · 2013-07-30T00:59:00

What is your need tell correctly, then only others can help you. Try to elaborate your need, tell us what you did and where you stuck. Without your proper requirements it will be hard to help you, anyway i am just giving you some idea from your question which i understand.

DataTable dt = new DataTable();
dt = ds.Tables["FooTable"];

foreach (DataRow dr in dt.Rows)
{
    MessageBox.Show(dr["Column1"].ToString());
}

To read a specific cell in a row:

C#

int rowNum // row number
string columnName = "DepartureTime";  // database table column name
dt.Rows[rowNum][columnName].ToString();

also refer these for Dataset examples
Dataset Description[^]
Working with Dataset[^]
Typed Dataset step by step tutorial[^]
DataGridView with Detail Edit Form - VS 2005[^]