nullskull.com faqs

ThreadPool.QueueUserWorkItem Multi-threading Code Sample

Mon, 04 Mar 2013 14:30:52 GMT

Here is a barebone example of how to use the ThreadPool to queue up tasks in a multi-threaded environment. read more

Generate Full Bank ABA Routing Number given the Federal Reserve Routing Symbol and ABA Institution Identifier

Thu, 16 Aug 2012 12:55:12 GMT

A bank ABA number our routing number is made up of three numbers, the federal reserve routing symbol (4 digits), the ABA institution indentifier (4 digits) and a check digit (1 digit). This SQL stored procedure returns the full bank routing number given the first two parts. read more

VB.NET Search and Replace in Word document

Fri, 27 Jul 2012 09:46:10 GMT

Sometimes it may be necessary to use a VB.NET applicaiton to do a Search and Replace in a MS Word document. This function does the search and replace in all sections of the Word document and saves it back to the disk with the same name. read more

Perform Server.MapPath When HttpContext Not Available

Thu, 12 Jul 2012 12:57:32 GMT

There are certain situations - particularly in Global.asax where you need to map a path but the HttpContext.Current property is null. Here is a simple method that works around this issue. read more

WPF ListBox and Creating Filtered Views

Wed, 09 May 2012 10:46:28 GMT

Here's a quick tip for easily implemention of filtered ListBox views of an ObservableCollection. This really comes into play when you want to hide items in a ListBox of a third party control that has styling that is not hidden when the item in the datatemplate is hidden. read more

Visual studio and .NET tip 14:- Implement interfaces with right clicks

Tue, 08 May 2012 14:31:14 GMT

In this Tip and tricks we will see how to implement interfaces with right click. read more

How to Take Ownership of a File or Folder To Delete It

Sat, 21 Apr 2012 18:11:34 GMT

If you perform an installation or upgrade of a Windows OS this often creates temporary folders called "windows.old". These folders are system folders and you may not be able to delete them. This is how to perform these actions. read more

Send authenticated SMTP email from SSIS

Tue, 17 Apr 2012 20:51:37 GMT

SSIS has a 'Send Mail Task', but it wont send via a SMTP server that requires authentication. By using the Script Task it is fairly simple to write some .NET code that will send an email via an authenticate STMP connection. Here is some sample VB.NET to send an email, it pulls all relavent information from variables that should be sent into the script from the SSIS package. read more

IHttpAsyncHandler, IRequiresSessionState, and IReadOnlySessionState Asynchronous Handler Issue

Sun, 02 Jun 2013 23:09:42 GMT

IHttpAsyncHandler and IRequiresSessionState are still used with asynchronous http handlers. Remember to use the HttpContext passed into the http handler. read more

XMLHttpRequest Asynchronous Multiple Request Sample Code

Wed, 21 Mar 2012 08:54:05 GMT

Here's a quick snippet demonstrating how to process multiple XMLHttpRequests asynchronously in JavaScript. read more

Create an array of strings in SSIS

Wed, 11 Apr 2012 22:24:03 GMT

If you need to use an array of strings in SSIS it is a little difficult to create it as a variable in the package. It takes defining the package variable as a system.object and calling a script task, either VB or C# (example is VB.NET). In my example I set System:Package name as a ReadOnly variable and User:Categories as ReadWrite, this is also the one defined as the system.object. The sample Main procedure sets the first element of the string array to the package name. read more

.NET ActiveDirectory Authentication Across Domain Controller

Mon, 12 Mar 2012 14:38:33 GMT

Using C# or VB.NET to authenticate a user in ActiveDirectory against a different domain controller can be accomplished using the code below: read more

dtSearch Remove Url Or Document From Index Using IndexJob

Sun, 19 Feb 2012 14:55:27 GMT

It only takes a few lines of code to remove a url or document from a dtsearch index. read more

How to display date difference in Days:Hours:Minutes format using TSQL

Wed, 15 Feb 2012 23:25:06 GMT

Often times on reports from Microsoft SQL server it is nice to display the difference between two datetime fields in something other than just the number of minutes, or days. This code snippet shows how to format the datediff output for minutes into hours, days, minutes format. It could easily be placed in a user defined function as well as have logic added to it for seconds and milliseconds if necessary. read more

Upcoming Microsoft MVP Summit 2012

Tue, 17 Jan 2012 20:10:59 GMT

Each year, Microsoft hosts the MVP Summit for thousands of Microsoft MVP's (Most Valuable Professionals) worldwide at the Microsoft campus in Redmond, WA. I've been fortunate to be re-nominated as an MVP each year since 2004, and I have never failed to get my butt to a summit each year. read more

ViewStateMode and EnableViewState

Tue, 17 Jan 2012 09:19:29 GMT

Often developers can get confused about the various settings for ViewState on pages and individual controls. This is because the settings themselves are confusing! read more

Text Too Big In Your Browser

Wed, 11 Jan 2012 20:50:43 GMT

No problem. Use this quick fix to adjust the size. read more

View print statements in your stored procedures in C# via ADO.NET

Sat, 31 Dec 2011 14:30:42 GMT

You may have "print" statements in your stored procedures or function in SQL Server for informational purposes. read more

DatatableToCSV

Mon, 26 Dec 2011 17:14:00 GMT

Often we need to convert a Datatable to a CSV - format file string to be able to save the file to the filesystem. Here's a neat little method to accomplish same read more

ASP.NET: Get the size of a file without downloading it

Fri, 23 Dec 2011 14:34:47 GMT

Some time ago I made a post on this subject, and I revisited it to check on timings. An easy way to get the size of a file over the web is to make a HEAD request for the resource and then examine the Content-Length Header. But there is another way: You can open a WebRequest, get the Response, examine ResponseHeaders["Content-Length"], and then immediately close the stream without reading any of it. Which do you think is faster? read more

Generating Random number between specified range

Fri, 23 Dec 2011 08:24:06 GMT

The Fuction generates a Random Number between the Specified range read more

How to Pad A String With Leading Zeroes

Tue, 20 Dec 2011 15:13:48 GMT

There are many situations where a value needs to occupy a certain number of characters, but must be padded with leading zeroes for storage. Here is a Func to do this: read more

Parse and Split Very Large Text Files Without Out of Memory Exceptions

Sun, 18 Dec 2011 14:49:34 GMT

From time to time you may have the need to read a very large file and split into an array. Streamreader is your friend here. read more

HEX String Conversions With LINQ

Thu, 15 Dec 2011 16:52:28 GMT

Often you may want to convert a string to it's Hexadecimal string equivalent, or convert a HEX string back to the original text. This is useful in situations where, for example, you would like to obfuscate the query string on a URL. read more

Read Files Simultaneously

Sun, 11 Dec 2011 17:43:03 GMT

A simple technique to read files simultaneously using a string array of file names read more

LINQ StartsWith

Thu, 08 Dec 2011 09:58:20 GMT

Equivalent of Like opertor in LINQ read more

Visual studio and .NET tip 12:- Pin debugging and commenting

Mon, 05 Dec 2011 08:45:43 GMT

Many times while debugging we would like to:- • See the debugged value after debugging has finished. • Enter comments while debugging and see these comments later. • Pin the debugger so that we can see the values while debugging. read more

jQuery CSS using AddClass

Tue, 29 Nov 2011 08:20:05 GMT

Using jQuery to Apply CSS to Asp.Net Controls read more

Visual Studio 2010 outlining hide code

Tue, 29 Nov 2011 08:20:32 GMT

Visual Studio 2010 hide code read more

See SQL Generated by LINQ to Entities query

Thu, 24 Nov 2011 08:22:13 GMT

Code to see SQL Query generated by LINQ read more

Visual studio and .NET tip 11:- Shortcut way to create Set and Get properties

Mon, 05 Dec 2011 08:45:20 GMT

In big project you have 100’s of classes and each of those classes can have lots of properties. read more

Visual studio and .NET tip 10:- Remove and reorder parameters

Tue, 15 Nov 2011 09:02:27 GMT

Many times as a developer you come across functions with lots of input parameters as shown in the below code snippets. In real projects the input parameters would be much higher as compared to the below code snippets. Some times for various reasons you want to shuffle them, reorder them or remove some of them. read more

Visual studio and .NET tip 9:- Conditional Breakpoints

Fri, 18 Nov 2011 08:17:18 GMT

As developer debugging is your routine job and you would like your debugger to debug smartly rather than monotonously. For instance in the below code we have put a debug point and we do not want our debugger to just break monotonously. read more

UrlEncode vs UrlPathEncode

Thu, 03 Nov 2011 19:16:49 GMT

The HttpUtility class offers several utility methods to encode Urls. Here are the differences. read more

Visual studio and .NET tip 8:- Get inner most exception

Tue, 15 Nov 2011 08:59:01 GMT

We all know exceptions get propagated from the last caller to the main caller. For instance let’s say from your static void main method you are calling “SomeMethod” and he in turn is calling “SomeMethod1”. read more

Visual studio and .NET tip 7:- Drag and drop code from tool box

Tue, 15 Nov 2011 08:58:42 GMT

As a developer you always need some common codes again and again. Rather than writing those common codes from scratch you would like to get them easily from some handy place. read more

Visual studio and .NET tip 6:- Skip debugging for certain lines of code

Tue, 08 May 2012 14:31:46 GMT

While debugging you often want to skip debugging on certain lines of code. For instance in the below code you have set the debug point to the first line, you would like to skip the in between lines and jump directly to “console.writeline” step. read more

Visual studio and .NET tip 5:- Encapsulate public properties with a single click

Tue, 08 May 2012 14:32:27 GMT

Many times due to project pressure and lazy attitude you violate encapsulation and create public variables for classes as shown below. Even though your inner heart knows that the best practice is to create set and get property function but your lazy attitude overrules it. read more

Visual studio and .NET tip 4:- Task reminders using visual studio

Tue, 08 May 2012 14:32:46 GMT

Many times we write comments in code to remind about certain tasks to be performed later and then we forget about the same as the comments gets lost in those million lines code. read more

General .NET tip 3: How to easily get connection strings?

Tue, 08 May 2012 14:33:32 GMT

Now many times as a .NET developer we need connection strings to connect to databases. Connection string are long and cryptic and very difficult to remember. In this tip we will see a easy way of getting connection strings. read more

Visual studio tip 2: Create methods from code snippets

Tue, 08 May 2012 14:33:11 GMT

In this section we will see a very interesting and useful trick of visual studio called the extract method. read more

SQL Server - block execution of a sql command for a certain period of time

Thu, 27 Oct 2011 13:52:01 GMT

SQL Server provides you the WAITFOR DELAY clause that helps you to delay the execution of a command for certain amount of time. read more

SQL Server - Quick way to find the rowcount in a table.

Thu, 27 Oct 2011 11:56:09 GMT

Use the Sysindexes table to find the number of rows in a table. read more

ASP.Net MVC - Use the AdditionalMetadata attribute to pass additional data to the views.

Thu, 27 Oct 2011 11:56:56 GMT

The [AdditionalMetadata] attribute is a powerful feature of MVC 3. You can make use of this attribute and pass additional data that will help you make judgements in scenarios where you need to display/take decisions conditionally. The following example makes it more clear. read more

ASP.Net MVC- How to change master page for a view at runtime?

Thu, 27 Oct 2011 11:57:30 GMT

You can pass the master page name when you return the ViewResult from the Controller's Action. read more

ASP.Net MVC - How do I apply a CSS class to html.ActionLink in MVC?

Thu, 27 Oct 2011 10:20:11 GMT

Use the ActionLink overloaded method that takes the html attributes that would be applied to the generated link. read more

Visual studio tip 1 : How to select code in a rectangular fashion?

Tue, 15 Nov 2011 08:45:29 GMT

When we select source code in visual studio it selects the complete source code , but what if we want to select the code in a rectangular manner? read more

Setting the Segment Terminator to Carriage Return without any charcter in EDI

Sat, 22 Oct 2011 10:40:12 GMT

This explains the procedure to set the Carriage Return Line Feed as the Segment Terminator in EDI. read more

Replace some text matches with url link with text as anchor text

Thu, 06 Oct 2011 22:29:05 GMT

Do you want to replace text on your web site with a link to a url, but don't want to do it everytime? An application of this could be everytime someone's name appears to replace it with a link to their bio page. To take this to the next level the attached code accepts a parameter to determine the chance that a particular match has of getting replaced, so it is possible to only replace 80% of the matches. read more

JQuery - How do I turn off/disable animations?

Fri, 30 Sep 2011 09:43:30 GMT

JQuery animations can be turned off/disable using the fx.off property. read more

JQuery - Get the selected item's text in a dropdown

Tue, 27 Sep 2011 11:19:07 GMT

Use the ":selected" modifier on the option element. read more

Method OverLoading in WCF, Exposing Overloded methods from wcfservice

Wed, 21 Sep 2011 15:53:31 GMT

How to Expose a overloaded mehod from a wcf service Contract. read more

Silverlight InvokeCommandAction Bind Button DataContext To UserControl DataContext

Sat, 15 Oct 2011 10:19:59 GMT

In Silverlight 4.0, you often times you need to bind to an ObservableCollection in your ListBox, DataGrid, etc. but also bind to events/commands using InvokeCommandAction that exist in your ViewModel. It gives you a way to send the current record in the list as a parameter to method fired from your Button/Hyperlinkbutton click event. The following example shows how. read more

LINQ Take & Skip

Mon, 19 Sep 2011 12:33:22 GMT

In some cases we want to Skip few items and take the remaining like in a List LINQ offers a greate way using Take() and Skip() Methods read more

JQuery DropDownList Get or set the selected item

Mon, 19 Sep 2011 11:26:00 GMT

The below sample explains how we can set or get the selected item for dropdownlist using JQuery. read more

LINQ OrderBY

Sun, 18 Sep 2011 23:04:41 GMT

LINQ offers a greate way to minimize your code. Here I will describe a small example of OrderBy using LINQ to sort a DropDownList. read more

Find a anchor tag inside a div using Jquery using Href attribute or Innerhtml

Fri, 16 Sep 2011 08:49:29 GMT

As we know the atg line of Jquery Is Write Less Do More, and it does the reflect the same with it ultimate by using little code we can perform the same task which previously we used to write with more lines. read more

Downloading the Windows 8 Developer Previews

Mon, 19 Sep 2011 22:37:01 GMT

Downloading the Windows 8 developer preview. If you have an MSDN subscription, there are also Windows Server developer previews. read more

How to add Exceptions to the Visual Studio main Debug Menu.

Sat, 27 Aug 2011 17:38:50 GMT

Recently I was working with another developer and I wanted to show him how to set his Exceptions to break on Command Language Runtime exceptions when they were thrown. This allows you to break into the debugger at the exact point where an exception is thrown rather than someplace up the call stack, and enables you to do real "pinpoint" exception debugging. However, to my surprise, this person did not have the "Exceptions" option in Visual Studio's top "Debug" menu item. read more

Windows 7 licensed copy turns into an evaluation copy.

Tue, 23 Aug 2011 17:42:54 GMT

If you use Windows update, and choose to install all updates automatically, then a copy of SP1 RC may be installed. And your licensed copy may turn into an evaluation copy. read more

How to prevent Databinding Leaks?

Thu, 01 Sep 2011 13:20:59 GMT

Databinding leaks can happen when you use a property in the Path which is not a dependency property and a class that does not implement INotifyPropertyChanged event. read more

ASP.Net - Global.asax Application_Start event does not fire

Sat, 13 Aug 2011 18:29:15 GMT

There are many threads on the internet that tell you to play with Session or any other web.config values to get Global.asax events working. If they do not work, then this tip is for you. read more

ASP.NET Master Page Controls and Accessing From a Content Page

Mon, 08 Aug 2011 08:40:59 GMT

The sample below describes how we can access the masterPage controls from the content page. Suppose we have a TextBox in the master page and we need to set the text to in the click event of Button which is in Content page. read more

Difference between IEnumerable and IQueryable

Mon, 01 Aug 2011 08:46:39 GMT

Here is the small sample that explains the difference between IEnumerable and IQueryable. read more

How to Add Tooltips to an ASP.NET Dropdownlist

Sat, 30 Jul 2011 12:33:21 GMT

A DropdownList can be enhanced with Tooltips for its items including the selected item. read more

Event Handling in Repeater Control

Wed, 03 Aug 2011 11:11:54 GMT

When controls are placed in Repeater Control we have to write OnItemCommand () Event for RepeaterControl and determine which control has raised the events. Events are bubbled between the controls that is if as button is placed in Repeater and the Repeater has OnItemCommand () Event and also the button has Click Event then both the events will be fired and so it is always safe to write events only for Top-Level Controls read more

MessageQueue StrConv Conversion To C#

Wed, 27 Jul 2011 10:17:05 GMT

If you are looking for a workaround concerning VB's StrConv and converting it to C# for use with message queues, the code below is what you need. This is also helpful for sending byte arrays to a message queue. read more

Using Delegate For Event Handling

Wed, 27 Jul 2011 07:45:16 GMT

One of the main uses of delegates is for handling the events read more

Using the c# runtime compiler to evaluate simple maths formulas

Tue, 26 Jul 2011 10:30:57 GMT

A simple class to demonstrate the usage of the c# runtime compiler and also a simple reflection execution of a static method read more

What is the difference between Stored Procedure and User defined funtion

Wed, 03 Aug 2011 11:12:58 GMT

The user defined function provides a mechanism for extending the functionality of the database server by adding a function that can be evaluated in SQL statements. A stored procedure is a subroutine available to applications accessing a relational database system read more

Numerical root finding using Secant Method in c#

Sat, 23 Jul 2011 16:20:45 GMT

This class provides a simple method to find the roots of a formula, similar to the GOTO function in Excel read more

Easy Read Data With Row Coloring:Coding

Fri, 22 Jul 2011 12:31:15 GMT

Very often mass data imported into excel spreadsheet for analysis or report to be presented, make us blur with similar information between one row and another. One way to make thing better is coloring the row with different color, but what shall we do with thousands of records? seem to be impossible with manual one. This comes to this piece of coding "Easy Read Data With Row Coloring", Hope this helps all happier with mass data analysis and save your time from tiring and boring daily manual task read more

Excel 2010- Enable the Developer toolbar

Tue, 19 Jul 2011 13:57:05 GMT

The developer toolbar is not enabled by default. Go to File - Options - Customize Ribbon. In the right side, you will find the "Developer tools" option. Check the box. and click OK. It will now appear. read more

C# - How do I convert an image from one format to other?

Tue, 19 Jul 2011 13:56:20 GMT

Use the Image class from the System.Drawing Namespace. read more

Excel automatically add trend line to your chart

Sun, 17 Jul 2011 21:36:33 GMT

Excel chart always be able to format or chage any properties then automatically applied to all series in that selected chart, but it is not easy like that to add trend line to the chart, you need to do series by series of chart. Here is the code help you to add trend line in just one click... read more

LINQ Join Operation Sample

Thu, 04 Aug 2011 09:40:38 GMT

For the sample i have taken theis generic list of type Player and Player_Data , which i will use this Lists as collections and perform the joins operations using Linq. read more

replaceAt() in javascript ,

Tue, 12 Jul 2011 07:42:04 GMT

The Sample shows a Functions to repalce a character in the string . read more

Sum the number of times a digit appears in a sequence

Fri, 08 Jul 2011 18:48:12 GMT

This was a response to my Google+ LINQ Quiz: Write a LINQ query that provides the sum of the number of times "1" is found in the sequence 1...100. read more

ASP.Net MVC - How to validate the route values? Can I control the routes using the type of the values?

Thu, 07 Jul 2011 06:52:12 GMT

One of the best ways is to use the RouteConstraint to validate the route values and then choose a route to controller. Route values that hold values of integer is the best example. If the route value is passed as string which cannot be converted to an Integer, we suffer with run-time and unhandled exceptions on our code. read more

jQuery - How do I Load a URL in a div

Thu, 07 Jul 2011 06:51:25 GMT

Use the Load method to load the html from a url into an element using jQuery. You will have to ensure that the url belongs to the same domain. read more

How to Determine if an Uploaded image is valid

Sat, 02 Jul 2011 12:40:46 GMT

Hackers often change the content type of their uploads, which could be malicious files. Here is how to guard against this. read more

C# - How do I properly clean com objects?

Tue, 28 Jun 2011 08:20:09 GMT

The ReleaseComObject method from the Marshal class helps you interact with unmanaged code. read more

Sharepoint-Get The Current User Name

Thu, 30 Jun 2011 08:00:19 GMT

Using This Code You Can Get The Current User Name... read more

Save Image In Your Specific Format

Thu, 30 Jun 2011 07:59:28 GMT

You Can Save Your Image Into Particular User Format Like Save As... read more

Build Web Browser Using Web Control in WPF Using C#

Thu, 30 Jun 2011 08:01:34 GMT

It Will Show You That How you Can Create An Application Like Web Browser & In That You Can Open Your Websites & Also Go Back & Go Forward Are There..... read more

Convert IEnumerable to DataTable

Sun, 26 Jun 2011 12:54:43 GMT

One of the problems with converting an IEnumerable to DataTable is the slowness of the reflection required. Here is a better way. read more

How to Disable ASP.NET Submit button after first Submit

Fri, 17 Jun 2011 13:57:14 GMT

If you have a form (for payment, etc) and you want to prevent multiple form submissions there are several techniques you can use. read more

Cannot access Session, Page_Load or other methods in a page with Page Methods

Thu, 16 Jun 2011 17:19:19 GMT

There are a lot of forum posts - both here and elsewhere - asking why you cannot access ASP.NET Page class lifecycle methods. The explanation is simple. read more

C# - Regular expression for validating Hex Color Codes.

Thu, 16 Jun 2011 08:11:44 GMT

Use the regex below for validating hexadecimal color code. It ensures that the value starts with a # and has valid 3/6 alphanumeric codes. You can use the same script in Javascript as well. read more

Windows 7 - Restore Previous versions of file or folder

Thu, 16 Jun 2011 08:10:47 GMT

Windows 7 has this beautiful feature added, that allows us to restore previous versions of file or folder. read more

ASP.NET Server-Side Code Blocks Legend

Wed, 15 Jun 2011 19:55:28 GMT

The following are the different types of ASP.NET server-side code blocks and what they are for. read more

Using LINQ Aggregate Method to concatenate strings to delimited string

Sat, 11 Jun 2011 13:24:40 GMT

The LINQ Aggregate extension method is very powerful. However, there can be performance issues on very large datasets, in which case the use of StringBuilder may be preferable. read more

Visual Studio - Support for HTML 5 Intellisense

Tue, 07 Jun 2011 13:30:54 GMT

The tip below shows you how to download and install the add-in which enables intellisense for HTML5 in Visual Studio. read more

Deserialize object xml string into an object instance

Sun, 05 Jun 2011 20:04:06 GMT

Given xml string that contains a deserialized object. This code will convert this string into the desired object. (Keep in mind that object has to be serializable) read more

Sort the Childs under Parents in Oracle Hierarchial Queries using siblings

Fri, 03 Jun 2011 13:34:45 GMT

This explains how to sort the child records under the parent records by using order siblings by clause read more

Retrieve content data in xml childnodes

Fri, 03 Jun 2011 16:26:35 GMT

This is to show you on how to retrieve content data in the childnodes of xml and show it in web page using response.write. read more

Add html tags in XML

Fri, 27 May 2011 09:31:17 GMT

What if we use xml as our database? And sometimes we also want to save the data as html or the whole html source code. We can do this by using character data or simply CDATA. The format for this is "" . Here's a simple snippets on how to add it in xml. read more

SQL Server - What data type should I use to store binary data?

Tue, 24 May 2011 23:32:20 GMT

Use Binary or VarBinary fields to store fixed or variable length. These were available in 2005 and 2008 versions only. read more

SQL Server - Change the datatype of a Timestamp column.

Tue, 24 May 2011 23:32:48 GMT

There is no workaround to change the datatype of a Timestamp column. You will have to drop the column and recreate it. read more

C# - How do I access command line arguments sent to my application from a non-main method?

Tue, 24 May 2011 23:33:19 GMT

Use the GetCommandLineArgs static method of the Environment class. It returns an array of the arguments. read more