Thursday, February 20, 2014

database connection

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

namespace DAL
{
    public class DBConn
    {
        private static SqlConnection Conn;

        private DBConn()
        {
        }

        public static SqlConnection getDbConnection()
        {
            try
            {
                if (Conn == null)
                {
                    Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["watsandatabaseConnectionString"].ConnectionString);

                    Conn.Open();
                }

                else if (Conn.State == ConnectionState.Closed)
                {
                    Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["watsandatabaseConnectionString"].ToString());
                    Conn.Open();
                }


                return Conn;
            }
            catch (Exception)
            {
               
                throw;
            }
           
        }
    }
}

Related Posts:

  • data access class(DAL) using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.SqlClient;namespace DALWatsans{… Read More
  • database connection using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Configuration;using Syste… Read More
  • Reservation Grid(.aspx) //delete confirm java script <script language="javascript" type="text/javascript">     function printPartOfPage(elementId) { &n… Read More
  • data access(reservation) using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.SqlClient;using System.Configur… Read More
  • reservation Grid(.cs) DALSky objDalSky;        protected void Page_Load(object sender, EventArgs e)      &… Read More

0 comments:

Post a Comment

Popular Posts

Recent Posts

Text Widget

Powered by Blogger.

Find Us On Facebook

Flickr Images

Recent Posts

Video Of Day

Random Posts

Facebook

Random Posts

Advertising

Popular Posts