How to disable download bar of chrome in selenium

By | January 14, 2021

currently we faced one issue in automation like buttons were not clickable due to chome download bar was overlapping on buttons. we googled lot of keywords like “disable-infobars chrome selenium, chromedriver disable-infobars not working, disable download bar chrome, How to disable infobar in Chrome browser in Selenium”. tried below things, MoveToElement method of action class,… Read More »

Earnings at risk You need to fix some ads.txt file issues to avoid severe impact to your revenue

By | January 10, 2021

“Earnings at risk – You need to fix some ads.txt file issues to avoid severe impact to your revenue.” OR “To prevent severe impact on revenue, download an ads.txt file then upload the file to the root level domain of each site” Recently my Adsense Account prompt with above errors. To prevent severe impact on… Read More »

Execute store procedure with input and output parameters

By | January 10, 2021

Syntax for Executing store procedure with input and output parameters is as below, Declare @Count int exec StoredProcedureName @inputparameters = input parameter value, @outputParamsOfSP = @rowCount output For example, Lets say you are building store procedure to get details of employee by passing employee Id, and that sp should return employee is permanent or contractual.… Read More »

Splitting a list or collection into chunks in C#

By | December 12, 2020

Problem Statement –  While working on project, one requirement came like client wants to save 50k of records into db in one go. which was taking lot of time to save long list of data to be proceessed and saved in database. also we had 8 api nodes and this code were running on signle… Read More »

How to hit breakpoint of global.aspx

By | November 10, 2020

Problem Statement- How to hit breakpoint of global.aspx or breakpoint in global.aspx not getting hit or application_start is not being hit  or global.asax – breakpoint not working Solution for all above statements are same as below, Open the global.aspx file by clicking on it. 2.  Add space at the end before closing end tag.    … Read More »

How to compare Columns of two tables in SQL Server

By | November 6, 2020

Background / Problem Statement – Many times while working on projects, we need to compare columns of two tables in sql server and find out what are matching columns and what are different columns in both the tables. Solution –  lets say we have below two tables, CREATE TABLE dbo.Employee ( EmployeeId INT ,fullName VARCHAR(100)… Read More »

How to clear nuget cache to get updated files on local

By | July 1, 2020

Many times we face wired problem like nuget packages are not getting updated locally, even after we take latest code and build or rebuild [or even clean and build] the solution properly. Then also latest nuget packages are not getting downloaded on local folder and we get some errors. Solution 1: Clean the Nuget cache… Read More »

Cannot Find One or More Components. Please Reinstall the Application

By | June 28, 2020

Recently i faced below problem while opening SQL Server Management Studio [SSMS], after trying multiple things finally it started working, Solution – Go to Control panel -> uninstall programs and search for Shell. [In my case its 2015, it may depend on different versions on our system.]   3. Right click and choose to repaire.… Read More »

How to Create drop down list of cell in excel

By | June 27, 2020

Steps: Enter name in each row of excel, for which you want to create list, e.g. as below, 2. Go to Data tab in excel sheet and click on data validations as highlighted below, 3. In data validation pop-up, Select list from allow dropdown and Select source =$B$5:$B$9 [rows of values for which you want… Read More »