Checking if values of Listbox/Combo box on a web page the same with values in DB?

[robocom]

Hello every body,
I have aproblem with checking: "If values of Listbox/Combo box on a web page the same with values in DB"? Can anybody help me to solves it?
Thanks and best regards,
Robocom

[ursvinod]

Hi

please paste the code that you have tried with.

[robocom]

Hi ursvinod,
I don't know how to write script for this situation. I think that:
- first: i must get value from listbox/combo box and put them into an array.
- second: compare these value with data in database.
I have studied QTP since last week and there are too many thing to learn. I hope you and everybody can help me in this situation!
Thanks and best regards,
Robocom

[basanth27]

Robocom-
You have the logic. You can easily find the solution too if you made a bit more research.

Whenever you post a question dont forget to give details like,

1. Version of QTP you are using ??
2. Application Interface host technology ?
3. Any third party controls or add-ins etc.

Now assuming it is a listbox let me extend to you a hint,

Code:

Dim oItems(100)

oListItems = obj.weblist("listbox").Getroproperty("all items")

oItems = Split(oListItems, ";")

oListCount = obj.weblist("listbox").Getroproperty("items count")
or
oListCount = Ubound(oItems)

For i = 0 to oListCount - 1 'Expecting values from DB are the same as on the application
     If Instr(oItems(i), ItemsfromDB(i)) >0 Then
             Reporter.reportevent micpass, "ITem exist", "Item exist"
         Else
               Reporter.reportevent micfail, "Item Does not Exist", "ITem does   not exist"
      End if
Next

I hope this helps. You may need to tweak it according to your requirement.

[robocom]

Hi basanth27,
Thank you very much for your reply. I will try it.