Posted By

rodrigoallves on 11/11/12

Tagged

Versions (?)

Last Edited at 11/11/12 08:23am

Statistics

Viewed 762 times

Favorited by 1 user(s)

Related snippets

DataBase Coonection Class

/ Published in: C#

Simple Class Connection for use in C# Code.

Methods:

- ReturnDataTable(string strQueryCommand)

- ReturnDataSet(string strQueryCommand)

- ExecuteQuery(string strQueryCommand)

- ReturnDataReader(string strQueryCommand)

Highlighted TextExpand

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
namespace Database
{
    public class DataSettings
    {
        private SqlConnection Conn;
        private SqlCommand Cmd { get; set; }
        private SqlDataReader Reader;
        private SqlDataAdapter dataAdapter;
        private DataSet Ds { get; set; }

public DataSettings()
        {
            Conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["connString"]);
        }

public SqlConnection OpenConn()
        {
            if (Conn.State == System.Data.ConnectionState.Closed || Conn.State == System.Data.ConnectionState.Broken)
            {
                Conn.Open();
            }
            return Conn;
        }

public SqlConnection CloseConn()
        {
            if (Conn.State == System.Data.ConnectionState.Open)
            {
                Conn.Close();
            }

return Conn;
        }

public DataTable ReturnDataTable(string strQueryCommand)
        {
            Cmd = new SqlCommand();
            SqlDataAdapter adap;
            try
            {
                Cmd.Connection = OpenConn();
                Cmd.CommandText = strQueryCommand;
                adap = new SqlDataAdapter(Cmd);
                DataTable dt = new DataTable();
                adap.Fill(dt);

return dt;
            }
            catch (Exception Ex)
            {
                throw Ex;
            }
            finally
            {
                Cmd = null;
            }
        }

public DataSet ReturnDataSet(string strQueryCommand)
        {
            try
            {
                OpenConn();
                Cmd = Conn.CreateCommand();
                dataAdapter = new SqlDataAdapter(strQueryCommand, Conn);
                Ds = new DataSet();
                Ds.Reset();
                dataAdapter.Fill(Ds);
                
                return Ds;
            }
            catch (Exception ex)
            {

throw ex;
            }
            finally
            {
                Cmd = null;
                CloseConn();
            }
        }

public void ExecuteQuery(string strQueryCommand)
        {
            try
            {
                Cmd.Connection = OpenConn();
                Cmd.CommandText = strQueryCommand;
                Cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {

throw ex;
            }
            finally
            {
                Cmd = null;
            }

}
        /// <summary>
        /// call datareader 
        /// </summary>
        /// <param name="strQueryCommand"></param>
        /// <returns></returns>
        public SqlDataReader ReturnDataReader(string strQueryCommand)
        {
            try
            {
                Cmd = Conn.CreateCommand();
                Cmd.CommandText = strQueryCommand;
                Reader = Cmd.ExecuteReader();
                return Reader;

}
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                Cmd = null;
            }
        }

}
}

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.