Pages

Monday, 13 May 2013

Connection Class fo Database in c#


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;

namespace DBMSProjectFinal
{
    public class DatabaseConnection
    {
        public static SqlConnection Myonnection;

        public static SqlConnection GetConnection()
        {
            if (Myonnection == null)
            {
                Myonnection = new SqlConnection();
                Myonnection.ConnectionString = @"server = (local) ; Initial catalog = eye_clinic ; integrated Security = true";
                Myonnection.Open();
            }
            return Myonnection;
        }
    }
}