Hi, I have a login page. To login in that page I need to have a valid usern

Hi,

I have a login page. To login in that page I need to have a
valid username and password, which is stored in database. I
imported that table to my DataTable in QTP (Global sheet).
Now I need to write a code in qtp so that I can login only
with valid username and data.

my condition is : I want to get username and password from
inputbox(which i did) and click on login button- which should
verify the datatable for username and password and if value
is present only then lofin else stop the testing.

DataTable contains columns : LoginName and Password

Code:

Rowcount= DataTable.GetSheet("Global").GetRowCount
msgbox "RowCount= " &RowCount,1
CurrentRow= DataTable.SetCurrentRow(1)

Do
Browser("").Page("").Frame("Frame").WebEdit("ctl10$ct
l00$ctl00$UserName$ctl").Set DataTable("LoginName",1)
Browser("").Page("").Frame("Frame").WebEdit("ctl10$ct
l00$ctl00$Password$ctl").Set DataTable("Password",1)
Browser("").Page("").Frame("Frame").Link("Login").Cli
ck
CurrentRow=CurrentRow+1
Loop Until CurrentRow>Rowcount

Can anyone help?

Thanks,
Priya

Question Posted / priya

3 Answers
5081 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hi, I have a login page. To login in that page I need to have a valid username and password, wh..

Answer / sandip mehra

First of all you have to add a sheet at the runtime data
table and then have to import the data from the excel sheet
so for that you have to use import sheet method, then after
follow all your process means you can use your script which
you have written over here.

follow the process and then let me know if you'll get any
error.

Regards
Sandeep Mehra

Is This Answer Correct ?

2 Yes

0 No

Hi, I have a login page. To login in that page I need to have a valid username and password, wh..

Answer / ranga

Hi,

import the data to data table and

Please check the syntax once

you written as ------DataTable("LoginName",1)

DataTable.Value("LoginName",1)

may be above is the problem getting the username n password.

Is This Answer Correct ?

0 Yes

0 No

Hi, I have a login page. To login in that page I need to have a valid username and password, wh..

Answer / rangalnrt

Hi,

May be you missed the syntax
you written---DataTable("LoginName",1)

DataTable.Value("LoginName",1)

Please check once whether it will solve your problem.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer