I got this unusual exception while working on an ASP.NET project:"Adding the specified count to the semaphore would cause it to exceed its maximum count error".I thought it is something related to SQL Server Database Connection String.After using Query Profiler I was able to run SQL queries directly without any...
There is an event named "OnClientContextMenuShowing" for Rad Treeview that calls javascipt function and passes 2 arguments "sender, args".The Args parameter contains The current selected TreeNode and Context Menu Items.You can enable or disable any Context menu item based on any attributes for the Current Selected Tree Node.Here is a...
DataTable Object has a Select Method which acts like Where in SQL Server. So if you want to write filter query you write the column name directly without Where and the filter expression you want.I made a simple example that creates a DataTable and fill it with some data and...
Let is say that we have the following Date 2007-04-05 10:13:14.109 and we want to get Year, Month and Day out of this date.There is a function named DATEPART() that can be used to archive this.DECLARE @MyDate AS DATETIME SET @MyDate = '2007-04-05 10:13:14.109' SELECT DATEPART(DAY, @MyDate) AS MyDay, DATEPART(MONTH, @MyDate) AS MyMonth, DATEPART(YEAR,...
Sometimes while developing an existing Web Application, I wanted to use jQuery function and I got this error "Uncaught ReferenceError: $ is not defined".There are some reasons causing it and ways to avoid them:Make sure the references to the jQuery scripts is loading first, but them in the head of master page or...
Assume that you have a string and you expect that this string might have some duplicated instances.String.Replace() is very good Function, but it will replace all the instances of the string. So to accomplish this you need to replace the first instance you find.The next code example can be used...
Sometimes we may need to create iFrames and use it within GridView or Repeater, and we want to pass some values to it.This example will show you how to create iFrame Programmatically and add it to a PlaceHolder.HtmlGenericControl myFrame = new HtmlGenericControl();myFrame.TagName = "IFRAME"; myFrame.Attributes["src"] = "MyPagePath"; myFrame.Attributes["id"] = "myFrame1"; myFrame.Attributes["name"] = "myFrame1"; myFrame.Attributes["width"] =...
I got this error when I tried to save a Page with lots of form fields to SQL Server Database.The default max number of form fields that can be post is 1000.In order to solve this error add this Line to your Web.Config File:<appSettings> <add key="aspnet:MaxHttpCollectionKeys" value="10000" /> </appSettings>
Sometimes I want to use SqlDataSource returned data programmatically and here is how you can do this,In this example I will assume that SqlDataSource ID is SqlDataSource1 which is the default ID:DataSourceSelectArguments args = new DataSourceSelectArguments(); DataView view = SqlDataSource1.Select(args) as DataView; DataTable dt = view.ToTable();
Any form is submitted when the user click on the submit button.But you may need to submit the form programmatically using JavaScript.JavaScript has the form object that contains the submit() method.Use the "ID" of the form to get the form object.Example:If the name of the form is "Form1", JavaScript code...
