Hi there,

I tried using

hasrows = reader.Read()

then assigning reapter.datasource= reader

The first record is still missing. Is there any other way I can achieve the same feature. Since I am using IDataReader to get the resultset back from Microsoft.Enterprise.Library I dont have any other option but to use IDataReader. IDataReader doesnt have HasRows properties.

Further suggestion will be appreciable.

Thanks in advance.

Hi there..

I was reading this since a couple of days.. Why are you using a IdataReader that supposed to be only an interface and you probably has a instance of an object on top of it???

Another set of ideas would be filling a datatable from this reader and then see if the datatable has rows...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Hi,

Since I am using Data Access Application block for the database connectivity the return type of ExecuteReader of the DAB is IDataReader and I cannot cast it to any other DataReader Type.

The another work around to fill the reader with DataTable will also cause the record to loose. Since I am using reapter control to display, it automatically does reader.Read() so incase I use reader.Read() before assigning it to the repeater control the record will get lost.

Any other suggestion, thanks

I don't know why you say you lose records loading a datatable, a datatable.load will make you lost records??.. but another workaround would be to just execute a count before actually filling the datareader...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Hi Gonzalo

Thanks for your reply.

Your work around to load DataTable didn't work because when I fill DataTable with the reader and check the DataRow count and return the result, DataReader is closed by then.

Can you explain more how to check the count of DataReader before assigning? Which specific property are you trying to refer.

thanks again

just execute an SQL like "SELECT COUNT(*) FROM table" and it will return the number of rows of your table.. alter the SQL to the where clause you use for filling the reader...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Hi Gonzalo,

Thanks for your suggestions, I used the DataTable.Load(reader) and used the DataTable.DataRow to find a count and used the DataReader for reading and it worked absolutely fine.

It worked finally!!

Cheers!

Glad it worked :)

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========