copy from datatable to DataReader

Question

1.00/5 (2 votes)

See more:

C#

VB

how i can copy from row number 1 to row number 6 in datatable
to DataReader
thnx for any help

Posted 30-Dec-10 12:41pm

Mostafa Elsadany

Add a Solution

Comments

Manfred Rudolf Bihy 30-Dec-10 18:47pm

"To DataReader"? I thought a DataReader was a source and not a destination. Please explain more clearly. Do you have any code samples to show us?

Mostafa Elsadany 30-Dec-10 19:11pm

public void x(OracleDataReader dr,DataTable tbl,int start,int end)
{

dr = tbl;// from start row to end row

}

this code is not valid but for explain

3 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)

Ali Al Omairi(Abu AlHassan) · Answer 1 · 2010-12-30T13:44:00

Solution 2

use SQLCommand.ExecuteReader just like:

Dim reader as DataReader = command.ExecuteReader

Posted 30-Dec-10 13:44pm

Ali Al Omairi(Abu AlHassan)

Comments

Mostafa Elsadany 30-Dec-10 19:45pm

thnx
but
i want fill datareader from datatable

Ankur^\m/ 13-Jan-11 5:39am

[moved from answer]
Ali Al Omairi wrote:
sorry, for miss understanding i thought that the table was in a database.
but if you have it read then why to read in again.
mostafa.elsadany wrote:
some case need to read from datatable into datareader

Ankur^\m/ 13-Jan-11 5:40am

Discussions come as a comment and not answer.

Ali Al Omairi(Abu AlHassan) 19-Jan-11 13:41pm

Sir, this is not of your business. Thank you.

Ankur^\m/ 19-Jan-11 23:33pm

Do you see that I have the powers to move your comments? And that's there for a reason.
Please read the FAQ's and follow the site policies.
Answer doesn't notify a 'commenter' but comment does. So it's quite possible the user may not know about your answer.
Add answer only if you are answering the question everything else goes into comment section.

Thank you for understanding.

Ali Al Omairi(Abu AlHassan) 25-Jan-11 16:50pm

Sir, thank you for advising me. but really i don't understand this portion.
"Do you see that I have the powers to move your comments? "

100 :rose:

Ankur^\m/ 27-Jan-11 1:57am

"i don't understand this portion - Do you see that I have the powers to move your comments?"

You added an "answer" to reply to the user. I deleted the answer and put that as a comment. You cannot do the same to others answer.

Ali Al Omairi(Abu AlHassan) 27-Jan-11 18:07pm

thank you for doing this, Alen.

Ankur^\m/ 27-Jan-11 23:11pm

You are welcome!

Ali Al Omairi(Abu AlHassan) · Answer 2 · 2010-12-30T15:05:00

Solution 4

sir, i can find no solution for your case other than implementing IDataReader interface (since DataReader is a connented Class and can not read from disconnected classes).

Posted 30-Dec-10 15:05pm

Ali Al Omairi(Abu AlHassan)

Comments

Mostafa Elsadany 30-Dec-10 21:14pm

thnx for help
but i want inherit datapadater
in new class and add new methods this cass
and i have many problem
so i will add new qustion you can see that
and thnx for aall help

Simon_Whale · Answer 3 · 2011-01-12T23:53:00

Solution 6

A Little research and you can do it by using the following example

reading contents from a datatable to datareader[^]

Posted 12-Jan-11 23:53pm

Simon_Whale

Updated 13-Jan-11 1:00am

v2

Comments

Mostafa Elsadany 13-Jan-11 6:19am

no i want take from datatable to datareader

Ali Al Omairi(Abu AlHassan) 19-Jan-11 16:48pm

thak you sir, i didn't know before. but why do you thing reading a datatable already loaded in memory can be useful.