05-09-2012 How to write a simple bat file (DOS command batch file) to find if a directory exists and delete it with all items in it (all files and sub folders). Simple DOS command explanation: IF EXIST will check the existence of the path you provide and execute the command you provide after that (toContinue reading “How To Write A DOS Bat (Batch) File To Check And Delete A Folder With Contents And Then Self-Destruct?”
Author Archives: Menol
ILT – Click-Once Deployment Error – Cannot Publish Because a Project Failed to Build
28-08-2012 Deploying using click-once setup is very easy. If you need a step by step guide to deploy a click-once, I’d recommend this article. Even though it is easy to create a click-once deployment package, the visual studio can face problems if you have third party ad-ons like DevExpress. If you get an error calledContinue reading “ILT – Click-Once Deployment Error – Cannot Publish Because a Project Failed to Build”
[post_list name=”listofposts”]
ILT – What’s the Common Name for Institutes Similar to Banks that Allow You to Save or Deposit Money?
21-08-2012 Common name for institutes similar to banks or building societies that allow you to save or deposit your money is – Depository Answer : Depository The word Repository is also a good candidate but find out below why it isn’t the most appropriate word: Depository VS Repository: A Depository is a place where youContinue reading “ILT – What’s the Common Name for Institutes Similar to Banks that Allow You to Save or Deposit Money?”
ILT – How to Add a Drop Down List (ComboBox) Into an Excel Cell
21-08-2012 How to configure an Excel cell, Excel Cell Range, Excel Column or Excel Row so that each of its cells will allow a user to select a value from a drop down list (combo box) rather than typing? Steps Select the cell, range, row or column you want to display with a drop downContinue reading “ILT – How to Add a Drop Down List (ComboBox) Into an Excel Cell”
ILT – How to convert string to enum in C#
15-08-2012 How to convert a value to an enum? How to find the matching enum value? Convert object to enum? How to use Enum.Parse method? Solution: Use the Enum.Parse method as shown below to convert your value to the appropriate enumerator type. Enum declaration – for explanation Actual casting Menol ILT
ILT – Easy Method To Manage or Map SQL Server User Access To SQL Server Databases
14-08-2012 How to easily map a SQL Server user to databases? Select the login you want to grant or deny access from the “Logins” sub-folder in the “Security” Folder in the SQL Server Right click on the user and select “Properties” Select “User Mapping” from the “Select a page” section You will see the listContinue reading “ILT – Easy Method To Manage or Map SQL Server User Access To SQL Server Databases”
Unable to cast COM object of type error {6D5140C1-7436-11CE-8034-00AA006009FA}
08-08-2012 I got this error today from SQL Server Management Studio. It occurred when I was trying to brows databases by expanding the “Databases” folder in the SQL Server Management Studio navigation tree. Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.VisualStudio.OLE.Interop.IServiceProvider’. This operation failed because the QueryInterface call on the COMContinue reading “Unable to cast COM object of type error {6D5140C1-7436-11CE-8034-00AA006009FA}”
Is Order Of OleDbCommand.Parameters Important
01-08-2012 The order of the parameters collection of an OleDbCommand must match the order to which those parameters appear in the SQL statement. Otherwise the .net framework will try to fill the parameters in your SQL statement according to the order of parameters in the OleDbCommand.Parameters collection. This can cause an Data type mismatch inContinue reading “Is Order Of OleDbCommand.Parameters Important”
How To Change The Combobox Index To Match A Target String
24-07-2012 I need to select “Item1” from the combo box. In other words, I need to select the index that matches the string in the “temp” variable and select that index. Solution Note: The FindString looks for a substring. If you need to perform an exact comparison then use Combobox.FindStringExact() Both these functions has overloadsContinue reading “How To Change The Combobox Index To Match A Target String”
I Learnt Today 