You can store data from the data table in recordset object. Then create another record set of ur excel(where u have expected data). Compare data in both the recordsets.
Regards, Ankit Nigam On 8/25/12, Jitu <[email protected]> wrote: > Thanks Shalabh and Prasad, > > @Shalabh > > I Am using ms access db for practice purpose then will move to sql server > and I did lot of googling too..but not get relevant answers ..thats y I > post here.. > > @Prasad, > I already mention that i know this steps I read data from DB using Scripts > > (connection ,recordset and using query )...Now I read data from DB and keep > > data > in data table ..now where you put expected data ? with which data you are > going to compare ? How you compare ? where you put Pass /fail result? > > > > > > > On Saturday, August 25, 2012 6:32:44 AM UTC-5, siva prasad wrote: >> >> Hi, >> >> >> We can performing the data base testing through >> >> qtp we 've to follow the following process. >> step1) >> create a object for database connetion >> set conn=createobject("adodb.connection") >> step2) >> create a object for recodset >> set rs=createobject("adodb.recordset") >> here adodb stands for activx dataobject database >> step3) >> pass the provider >> conn.provider="providername" >> for ms-acess- microsoft.jet.oledb.4.0 >> for oracle msdaora.1 >> step4) >> open your database >> conn.open "C:\programfiles\hp\quicktestprofessional\samples\flight32.mdb" >> step5) open record set write the query >> rs.open "select *form orders",con >> while not rs.eof >> msgbox rs(0) >> rs.movenext >> wend >> >> Thanks&Regards >> prasad k >> >> On Sat, Aug 25, 2012 at 4:20 AM, Tester >> <[email protected]<javascript:> >> > wrote: >> >>> Hi All, >>> >>> Can anybody guide me on that what is process to do database testing using >>> >>> QTP in real time? >>> >>> I know how to read data or table from ms access data base and SQl server >>> >>> .. >>> >>> Help will be really appreciate . >>> >>> Thanks, >>> >>> -- >>> You received this message because you are subscribed to the Google >>> "QTP - HP Quick Test Professional - Automated Software Testing" >>> group. >>> To post to this group, send email to >>> [email protected]<javascript:> >>> To unsubscribe from this group, send email to >>> [email protected] <javascript:> >>> For more options, visit this group at >>> http://groups.google.com/group/MercuryQTP?hl=en >>> >> >> >> >> -- >> prasad kopparapu >> +91-9032114331 >> > > -- > You received this message because you are subscribed to the Google > "QTP - HP Quick Test Professional - Automated Software Testing" > group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/MercuryQTP?hl=en > -- Sent from my mobile device -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en
