Asheej Kommery's .NET blog
-
How to delete all tables from the MS SQL database with many foreign key constraints
-
How to use Order by MONTH name of data type CHAR/VARCHAR in SQL
I have seen this question "How to use Order by MONTH name of data type CHAR/VARCHAR in SQL" in one of the forum. The reason why the programmer required this option is he/she is storing Data, month and year in 3 different fields in the database. Even though I don't agree to store the dates split in three different fields I thought I will explore how we can get desired result sort by month that even a varchar/Char datatype field.
-
Handler "PageHandlerFactory-Integrated" has a bad module "ManagedPipelineHandler" in its module list
Today when I was deploying a .NET application in a newly bult server I got an error "Handler "PageHandlerFactory-Integrated" has a bad module "ManagedPipelineHandler" in its module list".
I was bit surprised to see this error because I was doing a fresh installation on a fresh server. What my suspect was ASP.NET not installed properly on this server. Also that was the error message I was getting when I try to access the URL.
So I ran the below command to re-install the ASP.NET
%windir%\Microsoft.NET\Framework\v4.0.21006\aspnet_regiis.exe -i
You can run this from command prompt or directly in your RUN window which you can open by pressing window button + R -
Error: Toolkit requires ASP.NET Ajax 4.0 scripts. Ensure the correct version of the scripts are referenced. If you are using an ASP.NET ScriptManager, switch to the ToolkitScriptManager in AjaxControlToolkit.dll
Recently we have migrated one project from .NET 3.5 to 4.0 then the application which is using Ajax started throwing the error "Error: Toolkit requires ASP.NET Ajax 4.0 scripts. Ensure the correct version of the scripts are referenced. If you are using an ASP.NET ScriptManager, switch to the ToolkitScriptManager in AjaxControlToolkit.dll".
This was really frustrating one as we were using Ajax controls in many pages. Google search on this error has given me many solutions because many people were getting this error and solution was different for many people.
Here I am going to tell you how I was able to resolve my issue. It may or may not work for you but this is one of the solution. So it would be nice to check this option first.
Normal code you will be having in your 3.5 application will be like below,
<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
You may change above code like below,
<asp:ToolkitScriptManager ID="ToolkitScriptManager" runat="server">
</asp:ToolkitScriptManager>
Let me know your feed back after trying this option. -
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. System.Net.WebException: The operation has timed out error in SSIS Script Task
This is one of the error I got recently when I was running one SQL server Job. It was bit strange in my case.
-
Windows Azure Bootcamp
-
TOP WITH TIES in SQL Server
Normally we use TOP keyword to get the TOP n rows from the table. For example you have a table which contains employees’ details with salary and you wanted to know the top 5 salary earning employees details.
-
Error 4 The name 'ConfigurationManager' does not exist in the current context
You may get "Error 4 The name 'ConfigurationManager' does not exist in the current context" error when you copy the code from old version like 1.1. or 2.0. Microsoft would have given you enough warning by default when you use ConfigurationSettings in your .NET 2.0 or 3.5. From 4.0 onward it will throw error as "Error 4 The name 'ConfigurationManager' does not exist in the current context".
Solution is not that complicated, it is simple and can be resolved in two steps.
First, if you haven't added the reference to the System.Configuration then you must add the reference first.
So from your solution explorer right click on the Reference and open '.NET' tab and then locate the 'System.Configuration' option almost at the bottom.
Once you added the reference or you already have the reference then add the namespace to use ConfigurationManager like below,
using System.Configuration;
or you can use the code directly like below,
String strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString; -
How to validate TextBox inside Gridview using JavaScript
Validating TextBox or any other input control using JavaScript is one of the very common task we do in your ASP.NET application . What if we have to validate the TextBox inside the Gridview using JavaScript? Here we are going to see How to validate the TextBoxes inside the Gridview using JavaScript.
-
The database could not be exclusively locked to perform the operation. (Microsoft SQL Server, Error: 5030)
You might have seen "The database could not be exclusively locked to perform the operation. (Microsoft SQL Server, Error: 5030)" error when you try to rename SQL server database. This error normally occurs when your database is in Multi User mode where users are accessing your database or some objects are referring to your database.