InterviewSolution
Saved Bookmarks
| 1. |
In UFT, how to get data from database? |
|
Answer» Follow the given below code to get data from database − Set db = createobject (“ADODB.Connection”)db.Open “Provider = Microsoft.Jet.OLEDB.4.0;Data Source=G:\guru99\vb6\admission_project.mdb;Persist Security Info = False”Set rst = createobject (“ADODB.Recordset”)rst.Open “select*from Course”, db, 3id = rst. RecordCountFor i = 0 to id-1 Print rst.field (0) & rst.fields (1) & rst.fields (2) & rst.fields (3) rst.MovenextNext |
|