 |  |  |  |  |  |  |  |
Data collection from dataset using query
Please support our C# advertiser: Intel Parallel Studio Home
 |
•
•
Join Date: Oct 2008
Posts: 56
Reputation: 
Solved Threads: 0
Junior Poster in Training
hi,
i am doing a project using C#.
in my project, i stroed the database information into the dataset.
i do't know how to collect the data from dataset using query.
i know collect data from dataset using datarow method, but task is collect data from dataset by using query. if any body know please send ur information.
Thanks and Regards,
Karthikeyan S
i am doing a project using C#.
in my project, i stroed the database information into the dataset.
i do't know how to collect the data from dataset using query.
i know collect data from dataset using datarow method, but task is collect data from dataset by using query. if any body know please send ur information.
Thanks and Regards,
Karthikeyan S
Last edited by karthi_selva; Dec 8th, 2008 at 12:22 am.
•
•
Join Date: Oct 2008
Posts: 1,908
Reputation: 
Solved Threads: 273
You have to use a DbDataAdapter for that. It has properties like SelectCommand. A DataSet is what it's says : a DataSet.
Today is a gift, that's why it is called "The Present".
Make love, no war. Cave ab homine unius libri.
Danny
Make love, no war. Cave ab homine unius libri.
Danny
•
•
Join Date: Oct 2008
Posts: 56
Reputation:
Solved Threads: 0
Junior Poster in Training
•
•
•
•
Originally Posted by ddanbe 
You have to use a DbDataAdapter for that. It has properties like SelectCommand. A DataSet is what it's says : a DataSet.
i not understand what u saying, if possible please send the code.
•
•
Join Date: Mar 2008
Posts: 268
Reputation:
Solved Threads: 19
Posting Whiz in Training
You declare a dataAdapter or anything like that for example
This depends on your Database provider cos if you use SQL Provider U will have your dataAdapter declared as
C# Syntax (Toggle Plain Text)
This depends on your Database provider cos if you use SQL Provider U will have your dataAdapter declared as
SqlDataAdapter if you use Jet 4.0....and all u will use OleDBDataAdapter hope that makes sense though Some people get so rich they lose all respect for humanity. That's how rich I want to be.
•
•
Join Date: Oct 2008
Posts: 56
Reputation:
Solved Threads: 0
Junior Poster in Training
hi ,
this is for store the DB result into the Dataset.
ok after the execution of the aboue code. i like collect data from that dataset by using query not using datarow...
i think u understand
(my doupt is how to collects the data from dataset by using query no using datarow. for avoiding comparision operation i like to execute the query inside the dataset table. most of them told it is possible. but no body know the details.)
this is for store the DB result into the Dataset.
ok after the execution of the aboue code. i like collect data from that dataset by using query not using datarow...
i think u understand
(my doupt is how to collects the data from dataset by using query no using datarow. for avoiding comparision operation i like to execute the query inside the dataset table. most of them told it is possible. but no body know the details.)
•
•
Join Date: Mar 2008
Posts: 268
Reputation:
Solved Threads: 19
Posting Whiz in Training
Im trying to understand this... The above code is retrieving data from DataBase and store it on the dataSet using DataAdapter and dataset and a quiry which at the moment is Select statement, Now what kinda query wud u like to use to collect ur data from dataset, or maybe let me ask it this way, U wana read data from dataset and do what with it, maybe display it, using which control, I will have to admit I dont think I understand what ur asking
Some people get so rich they lose all respect for humanity. That's how rich I want to be.
•
•
Join Date: Oct 2008
Posts: 56
Reputation:
Solved Threads: 0
Junior Poster in Training
hi actually i stored some information in dataset.
i like to access that information from dataset using DML (query). this is a task.
currently we reterive the data from dataset by using datarow.
instead of process each element. i like to give dml query into dataset. that query reterive the data from dataset.
i think u understand my task.
i stored db informations in dataset because avoiding again and again access the db.
so from that dataset using dml query and collect the information.
if u understand please try to give idea, notes, sample code.
Regards,
Karthikeyan s
i like to access that information from dataset using DML (query). this is a task.
currently we reterive the data from dataset by using datarow.
instead of process each element. i like to give dml query into dataset. that query reterive the data from dataset.
i think u understand my task.
i stored db informations in dataset because avoiding again and again access the db.
so from that dataset using dml query and collect the information.
if u understand please try to give idea, notes, sample code.
Regards,
Karthikeyan s
|
Similar Threads
Other Threads in the C# Forum
- Previous Thread: How to refresh Combobox items
- Next Thread: What kind of aplication Can I create to test myself???
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest C# Posts
- Today's Posts
- Unanswered Threads
.net access algorithm array backup barchart bitmap box broadcast c# check checkbox client combobox control conversion csharp custom database databasesearch datagrid datagridview datagridviewcheckbox dataset datetime degrees development draganddrop drawing dynamiccreation encryption enum equation excel file form format formatting forms function gdi+ hospitalmanagementsystems httpwebrequest image index input install interface java label list listbox mandelbrot math mouseclick mysql namevaluepairs operator path photoshop picturebox pixelinversion post powerpacks programming property radians regex remoting resource restore richtextbox running... server sleep soap socket sql stack statistics stream string table text textbox thread time timer update usercontrol validation visualstudio wait webbrowser windows winforms working wpf write xml
