 |  |  |  |  |  |  |  |
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.
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 |
Latest C# Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for C#
.net access ado.net algorithm array barchart bitmap box broadcast buttons c# chat check checkbox class client color combobox control conversion csharp custom database datagridview dataset datetime degrees development draganddrop drawing encryption enum excel file files form format forms ftp function gdi+ httpwebrequest image index input install java label list listbox listener login mandelbrot math mouseclick mysql networking object operator oracle path photoshop picturebox post prime programming radians regex remote remoting resource richtextbox save saving serialization server sleep socket sql statistics stream string table tcp text textbox thread time timer treeview update usercontrol validation view visualstudio webbrowser windows winforms wpf xml
