Shaikh Sonny Aman’s Blog

previously www.mailtoaman.com

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 [...]

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 [...]