Posted By

amitkenny on 10/07/10

Tagged

database

Versions (?)

Last Edited at 10/07/10 04:19am

Statistics

Viewed 1266 times

Favorited by 2 user(s)

Related snippets

Database Connection Class

/ Published in: C#

Database connection class to be easily incorporated into any db based softwares, using SQLite 3

Highlighted TextExpand

class DatabaseConnection
{
        private SQLiteConnection conn;
        private SQLiteCommand sqlCommand;
        private SQLiteDataAdapter DB;
        private DataSet DS = new DataSet();

public DatabaseConnection()
    {
        conn = new SQLiteConnection("DataSource=ProfilerPro.s3db;New=False;Compress=True;");
    }

public SQLiteConnection Openconn()
    {
       if (conn.State == ConnectionState.Closed || conn.State == ConnectionState.Broken)
       {
                conn.Open();
       }
            return conn;
    }

public SQLiteConnection Closeconn()
    {
            if (conn.State == ConnectionState.Open)
            {
                conn.Close();
            }
            return conn;
    }

public void ExecuteQuery(string txtQuery)
    {

SQLiteCommand cmd = new SQLiteCommand();
            try
            {
                cmd.Connection = Openconn();
                cmd.CommandText = txtQuery;
                cmd.ExecuteNonQuery();
            }
            catch (Exception Ex)
            {
                throw Ex;
            }
            finally
            {
                cmd = null;
            }
   }

public DataSet returnDataSet(string txtQuery)
        {
            conn.Open();
            sqlCommand = conn.CreateCommand();
            DB = new SQLiteDataAdapter(txtQuery, conn);
            DS.Reset();
            DB.Fill(DS);
            conn.Close();
            return (DS);
        }

public DataTable returnDataTable(string txtQuery)
        {
            SQLiteCommand cmd = new SQLiteCommand();
            SQLiteDataAdapter adap;
            try
            {
                cmd.Connection = Openconn();
                cmd.CommandText = txtQuery;
                adap = new SQLiteDataAdapter(cmd);
                DataTable dt = new DataTable();
                adap.Fill(dt);

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

public SQLiteDataReader returnDataReader(string txtQuery)
        {
            SQLiteCommand cmd = new SQLiteCommand();
            try
            {
                cmd.Connection = Openconn();
                cmd.CommandText = txtQuery;
                SQLiteDataReader rd;
                rd = cmd.ExecuteReader();
                return rd;
            }
            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.