Using application/user settings in C# 2.0

This is a quick post for using application or user settings in C# 2.0. I found most of the articles dealing with it in VB which is pretty easy. All you need to access a setting called “ServerName” in Visual Basic is this line My.Settings.ServerName=”myServer” For more information about settings you can refer to MSDN…

10

Misleading error message when you create foreign key constraint

When you create new foreign key constraint in SQL Server 2005 and this constraint conflict with the data already exists in the tables, you will get an error message that might be misleading. Let’s say that you have 2 tables (depts and employee) and you want to create a foreign key constraint in the employee…

1

How to add null value in Management Studio (SQL Server 2005)

Updating database tables using Management Studio is a the easiest way during the development phase. If you do so, you probably need sometimes to update column to add a null value instead of the current value. To do so you just need to press CTRL+0 It’s also valid for Enterprise Manager for SQL 2000.  Enjoy…

3

Using test certificate with Reporting Services 2005 to establish SSL connection

If you are planning to publish your Reporting Services site to the internet then you need to secure the communication between the server and the clients. The industry standard to do so is to buy an SSL certificate from a public certificate authority (CA) like VeriSign. This would cost you much money especially that you…

4

Are you using IE7 and have a problem in accessing some site?

Internet Explorer 7 is the newest version of Internet Explorer(IE) will be launched on Windows Vista time. It will also be available for XP SP2 and 2003 SP1 users. It has many fancy features like new rendering engine(you will love it especially in LCD screens), Built in RSS aggregator, new enhanced security model and new printing engine. You can…

2