Linking Servers in SQL Server

Sometimes it is very important to link your SQL Server with antthor one since it is the best solution for some situations. This is very detailed article about How to link two SQL Servers and also how you can link an external datasources (Eg. Orcale, MS Access, Spredsheet, etc.)

Click here to read the article
By Neil Boyle

To SP or not to SP in SQL Server

This is sometimes a real big challenge we face during the development. This article have some real important stuff you should consider before taking your decision.

To SP or not to SP in SQL Server
by Douglas Reilly on MS SQL Server

Why Sealed Classes?

Why Sealed Classes?

The main purpose of a sealed class to take away the inheritance feature from the user so they cannot derive a class from a sealed class. One of the best usage of sealed classes is when you have a class with static members. For example, the Pens and Brushes classes of the System.Drawing namespace.

The Pens class represent the pens for standard colors. This class has only static members. For example, Pens.Blue represents a pen with blue color. Similarly, the Brushes class represents standard brushes. The Brushes.Blue represents a brush with blue color.

So when you're designing your application, you may keep in mind that you have sealed classes to seal user's boundaries ;).

By Mahesh Chand @

Some really nice articles on Sealed Classes and Methods in .NET.

Access dialog results from the parent form in c#

This is something very important for a developers who is migrating from VB to .NET. Even though this is explainning using C# it is not much ditingush from VB code.

  • Lets say you are having two Windows forms called Form1 and Form2 in your project. Form1 will be your parent form and Form2 will be the Dialog form.
  • Form1 will have a Command button and a Label control to display the input from the Dialog form(Form2). Dialogform(Form2) will have a textbox and two command buttons.
  • In the Form2 change the text properties of two buttons as OK and CANCEL.
  • Set OK buttons DialogResult property to OK and CANCEL buttons property to Cancel.
  • Set Modifier property of the textBox1 in the Form2 to Public or Internal. This will allow the parent form(In this case form1) to access the text value of the dialog form.
  • Write following code segement on click events of both buttons (Or create one method and change the delegation)
  • In the Form1 Command buttons Click event write the following code
    Form2 nfrm = new Form2();
    if(nfrm.ShowDialog() == DialogResults.OK)
    this.label1.Text = nfrm.textBox1.Text;
    • It is pretty simple and if you have any further quetions, corrections, suggetions please contact me.

    By Kaminda Berugoda

      Combining JavaScript with ASP.NET Web forms

      ASP.NET provides a new paradigm for developing Web-based applications. This includes a set of server-based controls that are analogous to HTML form elements such as text boxes, buttons, and so forth. The problem with these controls is the need to call the server. JavaScript provides an alternative for many tasks that negates the need to go to the server. Let's take a closer look at combining the power of JavaScript with ASP.NET.

      Read the full article in click here

      Microsoft release SQL Server 2005, VS .NET 2005 & BIZ TALK 2006

      The next generation of software development platform

      What's New in SQL Server 2005?

      What's New in VS.NET 2005?

      Andy Mc's .NET Framework FAQ

      The .NET Framework FAQ was first posted in July 2000, and is regularly updated. It covers the fundamentals of the .NET Framework including assemblies, garbage collection, security, interop with COM and remoting. Newcomers to the .NET framework may wish to read the FAQ from top to bottom as a tutorial. More experienced practitioners may prefer to consult the contents list for topics of particular interest.

      This FAQ was inspired by discussions on the DOTNET mailing list. The list has now been split into several DOTNET-X lists - for details see

      Christophe Lauer has translated the FAQ into French. Royal has translated the FAQ into Chinese.

      If you like this FAQ, you might be interested in my C# FAQ for C++ Programmers.

      Click here to visit the site

      Sri Lanka .Net Forum

      A nice place to put your questions.
      Blog Directory -