Visit 'LiveWorld24.tk' for Live world..............

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using net.ERP.Constants;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace net.ERP.Utility

{

    class DatabaseConnector:CommonConstants

    {

        private string mpristrDBConnectionString = null;

        public static SqlConnection gmpubstasqlconnSQLConnection = null;

        public static SqlConnection gmpubstasqlconnSQLConnectionTemp = null;

        public void mpubvConnectDatabase(string pstrServerName)

        {

            try

            {

                mpristrDBConnectionString = "Data Source=" + pstrServerName + ";Initial Catalog=" + gmpubcstrDatabaseName + ";User ID=" + gmpubcstrUserName + ";Password=" + gmpubcstrPassword;

                gmpubstasqlconnSQLConnection = new SqlConnection(mpristrDBConnectionString);

                gmpubstasqlconnSQLConnectionTemp = new SqlConnection(mpristrDBConnectionString);

            }

            catch (Exception pexpDBConnection)

            {

                MessageBox.Show(pexpDBConnection.Message);

            }

            finally

            {

                mpristrDBConnectionString = null;

            }

        }

    }

}