Latest

SQL : How to use SQL Profiler with SQL Server Express Edition

SQL Server Express is a free edition of Microsoft SQL Server family that although fully functional, it has some technical limitations like maximum database size per database. It also has some features missing from paid editions. One of those features not available with Express edition is SQL Profiler. In this post I will list the alternative tools for SQL Profiling that can be used with either SQL Server Express or can be used as the SQL Express replacement.

Read More

.NET : How to save DataTable to Database Table using C#

Recently I wanted to save DataTable data into database. I assumed this would be easy using Entity Framework, but it turns out it is not, since DataTable consists of rows and columns while the Entity Framework deals with objects. Another way is to use ADO.NET by iterating through the rows in the DataTable and insert each row using SqlCommand and INSERT statement, but there is an easier way to accomplish this and that is by using SqlBulkCopy class, which is the focus of this article.

Read More

ASP.NET : How to solve logging out before timeout expires problem

A while ago I had a task of setting up an old ASP.NET 3.5 application on a shared hosting server and after I was done, the application worked as it should except for one important bit. The application used a Forms Authentication to authenticate users and after users logged in they were getting logging out and redirected to login page after a really short amount of time, usually only after a few minutes.
In this article I will show different ways I tried to locate this problem and how I finally managed to fix this issue.

Read More

SQL : How to solve Northwind Database Install Error in SQL Server 2012

Recently I was going through a database programming tutorial that used Northwind Database in code examples, so I thought “No problem, I’ll quickly add that database to my SQL Server 2012”. I assumed this would be easy but to my surprise that wasn’t the case.

In this post I will show you what problems I encountered while trying to install Northwind database and how I finally managed to make it work.

Read More

DotNet : How to solve NUnit Error – Unable to find test in assembly

The other day I wanted to learn something new so I decided to try a little Unit Testing using Microsoft .NET. After looking at different Unit Testing Frameworks I chose to use NUnit Framework. I then tried an example found on the web and after the project was built, I loaded NUnit GUI and opened unit test assembly, but to my surprise, the NUnit GUI was giving me Error message. It was telling me that the Test load failed with detailed error: SystemApplicationException: Unable to find test in the assembly.

In the end I found three different ways to make NUnit work and each one will be shown in this article.

Read More

Winform : How to create a new popup window using C#

When I started to learn WinForm programming, one thing that I wondered was how to create additional window forms on already existing Winform Project. For example I wanted to create a popup window for editing purposes. I knew what code to write that would instantiate a new form but didn’t know how to edit that form in the designer.

Read More

.NET : How to make ELMAH log HttpRequestValidationException Error

ELMAH (Error Logging Modules and Handlers) is an open source error logging framework for ASP.NET and for ASP.NET MVC. When added to the web application, exceptions that are thrown will trigger event handlers in the ELMAH that will log nearly all unhandled exceptions, but using ASP.NET 4 there is one Exception type that the ELMAH v1.2 is unable to log and that is HttpRequestValidationException.

In this article you will learn three ways to make ELMAH log this specific exception.

Read More

Share this page

Back to Top