 |  |  |  |  |  |  |  |
Data collection from dataset using query
Please support our C# advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!
 |
•
•
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,839
Reputation: 
Solved Threads: 266
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 asp.net bitmap box broadcast c# check checkbox client combobox control conversion csharp database datagrid datagridview dataset datetime dbconnection decryption degrees design developer draganddrop drawing encryption enum eventhandlers excel file firefox focus form format forms function gdi+ grantorrevokepermissionthroughc#.net hospitalmanagementsystem image input install interface java libraries list loop marshalbyrefobject math mouseclick movingimage mysql netcfsvcutil.exe numeric operator path photoshop php picturebox pixelinversion platform polynomial post programming properties radians read regex remote remoting richtextbox server sleep socket sql statistics string stringformatting study system.servicemodel table tcpclientchannel text textbox thread time timer update usb usercontrol validation visualstudio webbrowser winforms wpf wpfc# xml