I am new to selenium. I want to verify data shown in grid on my web application page with database value.
I have gone through blogs, and what I have found is:
Using Selenium Webdriver in C#:
i. Connect to database and execute the query and get data.
ii. Get parent element of data shown on screen and loop through its child element and match the data.
Is there any better way available to validate data (let's say data in grid) shown on web page with database using selenium webdriver?
Using IDE: I have searched for this but I have not found any way to connect selenium IDE with database (in my case, SQL Server).
Let me know if I have missed something or misunderstood the concept.