Agha Usman

The underlying provider failed on Open

aghausman12 — Sat, 01 Sep 2012 18:13:00 GMT

The underlying provider failed on Open is an entity framework error and with a simple fix it is little difficult to sort out what is going wrong. 1) if you are using IIS 7 with Integrated Security in connection string. Make sure your IIS user have appropriate...(read more)

Ambiguous in the namespace problem

aghausman12 — Mon, 28 Feb 2011 16:05:02 GMT

From the last few days, I was ignoring an error that keep coming at the compile time. I spent some two hours on it before but didn’t get it work. The error is quit confusing and of course difficult to manage. 'ApplicationSettingsBase' is ambiguous in...(read more)

Getting started with Unit Testing in C#

aghausman12 — Fri, 07 Aug 2009 19:04:18 GMT

Introduction: In this post, I will explain you how can we write a unit test in c#. It is a basic guideline for those who wants a quick start. Unit testing is an integral part of any software that is developed. It is an advantage which most of us are either...(read more)

Get Countries Name in .Net

aghausman12 — Sun, 26 Jul 2009 13:37:06 GMT

Introduction: In this post, I will explain you how can we get the countries name filled in any collection using .net without using any database. It is a regular task, which we all as developers did some past day but the difference is we used database...(read more)

Show Loading Message in Asp.net AJAX

aghausman12 — Sun, 19 Jul 2009 19:47:00 GMT

In this post, I will explain you how can we show Loading message in asp.net ajax without using Update Progress. Now some one may asked, why do I want to skip Update Progress ? Well, there can be several reasons for this, fist of all you have to work on...(read more)

Migrate from WordPress to BlogEngine.net

aghausman12 — Sun, 19 Jul 2009 18:42:07 GMT

In this post, I will explain how to migrate a blog running on Word Press (Self Hosted) to BlogEngine. But before I start let me say, that Word Press simply rocks. The reason why I plan to switch my blog is customization. Since I am a dotnet geek, I really...(read more)

How to show and select month/year in Calendar Extender

aghausman12 — Sat, 30 May 2009 22:16:09 GMT

In this post I will explain you, How to make calendar extender control to show month / year view by default and instead of selecting dates how can we use calendar extender to select months. Before I start, let me say that I got extensive support from...(read more)

Show images on Grid View from File Stream SQL Server 2008

aghausman12 — Mon, 25 May 2009 21:15:00 GMT

Background : In my last post about SQL Server 2008 new feature File Stream (Saving and Retrieving File Using FileStream SQL Server 2008) , we did an example of saving an image to the file stream and then retrieve it back and make it available for download...(read more)

Custom Paging in Grid view

aghausman12 — Mon, 18 May 2009 20:17:00 GMT

So, it takes too long for me to write this post. even though I completed the coding stuff a week back but it is really hard to manage time these days. In this post, I will explain and demonstrate you how to create custom paging in Grid view control. Paging...(read more)

Datatable to JSON

aghausman12 — Sat, 16 May 2009 11:53:29 GMT

In this post I will explain you, how can we serialize Datatable to JSON. So that, it can easily pass to JavaScript to get the AJAX done. First of all fill a Datatable with some results. DataTable dt = new DataTable(); SqlConnection objSqlCon =...(read more)

Authenticated File Access using HTTP Handler.

aghausman12 — Thu, 07 May 2009 21:21:50 GMT

In this post I will explain you how authenticate the request directly coming to access a file that is downloadable. some thing like *.pdf or *.zip. Mostly, people make it working by creating an *.aspx page and then write binary of that file in Response...(read more)

How to pass parameters to the dynamically added user control

aghausman12 — Wed, 15 Apr 2009 15:35:54 GMT

In this post, I will explain how you can pass parameter to the dynamically added (from code behind) User Control. Most of you might aware of how we can achieve this in web application project. Following is the code for that 1: Dim objCon As Control =...(read more)

Get Repeater Control Output in String

aghausman12 — Mon, 13 Apr 2009 15:30:48 GMT

In this post I will share with you a small code snippet which will help you to get the repeater control output in string variable. 1: Dim sb As New StringBuilder() 2: Dim objHtml As New HtmlTextWriter( New System.IO.StringWriter(sb)) 3: 4: If dt...(read more)

Storing/Retrieving Hierarchies In SQL Server Database

aghausman12 — Mon, 16 Mar 2009 13:45:30 GMT

Hierarchies are one of the most important part of many applications. It can be in shape of categories, family tree, organization charts etc. Maintaining hierarchies in data source like XML is not a big deal but when it comes to the database like SQL Server...(read more)

Saving and Retrieving File Using FileStream SQL Server 2008

aghausman12 — Sun, 15 Mar 2009 20:08:42 GMT

FileStream data type is a very important feature of SQL Server 2008 and gradually getting popular amongst developer for it’s feasibility. And in the past few days specially after “ Configure SQL Server 2008 for File Stream ” post. I received several feedbacks...(read more)