Get Filenames in a Folder
There might be a requirement to list all the filenames inside a folder. The steps below would be useful: 1. Hold the “Shift” key, right-click the folder containing a list of files and select “Open Command...
Read MoreCategory: Programming Notes
Count records using LINQ
I need to get the number of Tasks in a project for the MaxValue property of Telerik ProgressBar and the numbers of completed tasks for its Value property. Below are the codes I used: Public Sub progressBar() Dim projectID As...
Read MoreHow to rename ID Field in a Sharepoint List
Requirement: Rename ID field in a SharePoint list! We had a list with ID column added to the view to provide unique auto number feature. User wants to rename ID field to “Change Request Number” as it sounds more...
Read MoreSharepoint 2013 Log in as a different user missing, a simple workaround
In their infinite wisdom, Microsoft decided to remove the ‘sign in as another user‘ option from the UI. For consultants and developers who need to test their solutions in an ongoing manner, user accounts need to be switched in...
Read MoreCould Not Find Database Engine Startup Handle Error
My fresh installation of MS SQLSERVER 2014 in Windows Server 2012 was not successful due to the error mentioned in the title of this post. Its resolution is presented below: I remove the SQLSERVER 2014 installation using the...
Read MoreStylesheet not working on pages from other folders
I used a master on pages of my ASP.NET application. CSS and Script files were used in the master using a reference lines as: <link rel=”stylesheet” href=”css/style.css” runat=”server” />...
Read MoreHow to run aspnet_regsql
Personally, I prefer to use the wizard in running the executable file. Just locate the file from C:\Windows\Microsoft.NET\Framework\[framework version]\aspnet_regsql.exe) and run the file as Administrator. Provide information...
Read MoreFinding special character in Excel cell
To find special character in excel cell and place a remark if found, you may use the formula below:...
Read MoreChanging the data source of Form Authentication
I created my web application using the Web Form template in VS 2013. It was a quick installation setup where sample pages and the login module were already included. The login uses the Default connection string which is sourced...
Read MoreAccessing the ASP.NET Web Configuration Tool in Visual Studio 2013
The ASP.Net Web Configuration Manager is not anymore available in Visual Studio 2013. If you need to run it in your development server or machine, the steps below would be of great help. Before doing these steps, ensure that...
Read MoreRemove hyperlinks in Excel
Scenario (Applies to MS Excel) When you type an entry in your worksheet that begins with any of the following prefixes, Microsoft Excel automatically creates a hyperlink: • http:// • www. • ftp:// • mailto: •...
Read MoreQuick Search Function
Scenario (Applies to MS Access) I have a main form (frmSearch) with a subform (sfrmNamesList) by which its data source is a query (qrySearchNames). In a query, I added a Search field concatenating the fields that are included in...
Read More