Ternary Operator: ” ?: ” Ternary operator means simple if else condition in one statement based on condition. we can say this is dicision making operator. Syntax: var output = Boolean expression ? first value : second value It three parts, First part (before ?) includes conditional expression that returns boolean value true or false. Second part (after ? and before ‘:’… Read More »
How to uninstall a Windows service if the files do not exist anymore? Method 1 – We can use the SC tool (Sc.exe) Open a Command Prompt using windows + R and write Syntax: SC Delete <Service-name-which-you-want-to-delete> Example: we wanted to delete “ABC” service, DESCRIPTION: SC is a command line program used for communicating with the NT Service… Read More »
How to check if a column exists in a SQL Server table, Syntax: IF EXISTS(SELECT 1 FROM sys.columns WHERE Name = N’columnName’ AND Object_ID = Object_ID(N’schemaName.tableName’)) BEGIN — Column is exists in DB END Example: Let’s Check wether address column is present in Employee table or not. IF EXISTS(SELECT 1 FROM sys.columns WHERE Name =… Read More »
Syntax: ALTER TABLE {TABLENAME} ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL} CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE} WITH VALUES Example: Alter table Employee Add Address varchar(max) null default ‘Pune’
Path.GetDirectoryName(Application.ExecutablePath); will return the current directory in windows service. To work above code you need to add one dll reference System.Windows.Forms.dll. Some developers tries Directory.GetCurrentDirectory(), which actually returns C:\Windows\System32.
Some of the interviewer’s favourate question or we can say common interview question is What is Lazy Loading in C#.Net and when to use it Lazy Loading in C#.Net Lazy loading is the concept in which we delay the loading of the object until the point where we need it. In simple terms loading the objects on… Read More »
Once, we had one situation where foreach loop is used to loop though data rows in datatable and we were marking DB call though that loop. [Calling DB functions inside loop is not good practice, but that code was very old and we just wanted to improve some performance.] but we wanted Parallel foreach on DataTable.… Read More »
How to fix destination folder already exists in wordpress for plugin This error ‘Destination folder already exists in wordpress’ usually comes while installing any plugin or theme. In this article, we will show you how to fix destination folder already exists error in WordPress. Reason for getting this Error: This error comes due to same folder… Read More »
If interested Kindly do send mail to Jatinnahar15@gmail.com
1) Press CTRL+h to open Replace word window. 2) Type \\r\\n in “Find what” and \r\n in “Replace with”. 3) Finally, select search mode Extended (\r, \n, \t, \x…, \0) and click “Replace All”.