thanx michael pallavi

Hi Vasudevan, Thank you for your help ..:) pallavi

Write a proc that does the insert for multiple records. XML is the best way to pass multiple records, OpenXML can turn that into a table, which you then insert into your main DB. Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Pallavi Bhoite wrote: as per requirement i have to use datareader Ok, then you just have to (more or less) rewrite the Fill method in your own code. --- single minded; short sighted; long gone;