Shaikh Sonny Aman’s Blog

Lets learn and share!

ASP.net C#: Easily switch between SQL server database and access by an abstraction layer

Problem:
You are developing an asp.net application which runs on MS SQL server on the back end. You need to show a demo to a person who does not have MS SQL Server. You have to create or export to a access database.
or
Learning ASP.net,C# newly
Challenges:
You have to choose SqlConnection ,SqlCommand or OleDbConnection, OldeDbCommand for [...]

How to create MS SQL Server 2005 unique key step by step example

Looking at the title many of you may think what is the justification to write so basic stuff!
I admit. Honestly I also admit that I was searching for this over Google ! I am totally new to SQL server environment and also have no idea about its IDE. MySQL and PostgreSQL are the two DBMS [...]

JQuery custom attribute selector, extending JQuery

Problem: In my current project, i had many links and divs whichperforms some tasks as they are clicked. say, some are links inthe list which shows categories, clicking this links, i need to showthe items. Again, clicking each item, i need do some other tasks. Inthis way, all the action links/divs can be categorized.
I [...]

ScribeFire improvements 2008-04-13

Wow!! just finished writing the earlier post on scribfire and needto write another about its improvements.
1. Tabbed edit:Now, you can create and edit multiple post at a time ! 2. New control panel:The left control panel is now with new look and features!! 3. Youtube and flickr addon!!!Now, you can share your Youtube and [...]

ScribeFire — Fireup your blogging

Great bloggin tool !

SQL Server permission problem in vista solved

Recently I migrated to Window Vista and enjoying its cool looksand features.
I was facing a weird problem with SQL Server. I am using SQL Server2005 express edition that was available with VS 2005.
When I was trying to create a database the following problem raised:
 
As a result, I could not create any Database !! I [...]

Assembla: Online project, with free svn,file upload,tickets and everything !!

I was looking for an online space where I can securely host my project.Google took me to Assembla after knocking a number of doors. Its an one stop solution for projecthosting.
You can create teams, have scrum meeting,chat, manage your money(!),have wikis, different pages for a project…. etc etc.
Above all, it will allow you to [...]

How to unit testing with Visual Studio Team System 2008

 
Testing is a vital part of any software project. In modern developmentprocesses it is an umbrella task.
Visual Studio Team System 2008 offers an excellent way to perform various types of test. It made testing as easy as it gets.
Lets see how to perform unit testing over a class.
Steps:

Create a web project.
Add a new class
write [...]

Windows live Writer

Have you ever tried windows live writer ? Try it once. I bet, you wont be able to stop blogging !!
Its a great blogging tool with every feature you will ever need. Have a look at the screen shot:

Sorry for the background, I forgot to close the VS 2008. )
The first tool that could [...]

Subversion with Visual studio 2008: free open source svn client AnkhSVN

Recently I have installed Microsoft Visual Studio team system, 2008. This studio simply rocks. Enhanced speed is giving me a joyful experience!
Anyway, version controlling is a major issue for any development and I never liked VSS nor used it, rather I am used to with using subversion. For windows, I like TortoiseSVN. Its simply superb [...]