Learn Oledb connection

Hello,
Here is a complete code detail of oledb connection.

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Drawing;
using System.Data.OleDb;

public class clsGeneral
{
DataTable dt = new DataTable();
public static string storeId = "";
public static string store = "";
#region :: Variable Declaration ::

public static string cnString;
#endregion


public clsGeneral()
{
try
{
//******* change connection path of window application***********/
string AppPath1 = System.IO.Directory.GetCurrentDirectory();
string AppPath = AppPath1.Substring(0,AppPath1.Length-10) + "\\RMC30.MDB";
cnString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AppPath + "";
// cnString = ConfigurationSettings.AppSettings.Get("name");
}
catch (Exception)
{
}
}
/*********** Execute non qeury***** for insert delete, update*********/
public bool execute_NonQuery(string sql)
{
try
{
OleDbConnection con = new OleDbConnection();
con.ConnectionString = cnString;
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
con.Open();
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
con.Dispose();
cmd = null;
con = null;
sql = null;

}
catch (Exception er)
{
}
return true;
}
//******** select query*****************//
public object execute_Scalar(string sql)
{
string NewID = "";
try
{

OleDbConnection con = new OleDbConnection();
con.ConnectionString = cnString;
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
con.Open();
NewID = Convert.ToString(cmd.ExecuteScalar());

cmd.Dispose();
con.Close();
con.Dispose();
cmd = null;
con = null;
sql = null;

}
catch (Exception)
{

}
return NewID;
}
//********* get Record in Datatable*******/
public DataTable get_Records(string sql)
{
DataTable ds = new DataTable();
try
{
OleDbConnection con = new OleDbConnection();
con.ConnectionString = cnString;
con.Open();

OleDbDataAdapter adp = new OleDbDataAdapter(sql, con);
adp.Fill(ds);
adp.Dispose();
con.Close();
con.Dispose();
sql = "";

}
catch (Exception)
{

}
return ds;
}
//********* fill in Datagrid***********//
public bool fill_Grid(string sql, ref System.Windows.Forms.DataGrid dg)
{
try
{
OleDbConnection con = new OleDbConnection();
con.ConnectionString = cnString;
con.Open();
DataSet ds = new DataSet();
OleDbDataAdapter adp = new OleDbDataAdapter(sql, con);
adp.Fill(ds);
dg.DataSource = ds.Tables[0];

ds = null;
adp.Dispose();
con.Close();
con.Dispose();

}
catch (Exception)
{

}
return true;
}


public bool fill_Checkbox(string sql, ref System.Windows.Forms.CheckedListBox cb)
{
try
{
OleDbConnection con = new OleDbConnection();
con.ConnectionString = cnString;

con.Open();
DataSet ds = new DataSet();
OleDbDataAdapter adp = new OleDbDataAdapter(sql, con);
adp.Fill(ds);
cb.DataSource = ds.Tables[0];
ds = null;
adp.Dispose();
con.Close();
con.Dispose();

}
catch (Exception)
{

}
return true;
}

//************* fill datatable using dataAdapter********/
public bool DataAdapter(string sql, DataTable dt)
{
try
{
OleDbConnection con = new OleDbConnection();
con.ConnectionString = cnString;

con.Open();
OleDbDataAdapter adp = new OleDbDataAdapter(sql, con);
adp.Fill(dt);
adp.Dispose();
con.Close();
con.Dispose();

}
catch(Exception )
{

}
return true;
}

public bool fill_combo(string sql, ref System.Windows.Forms.ComboBox cmb, string cmbName, string cmbVal)
{
try
{
OleDbConnection con = new OleDbConnection();
con.ConnectionString = cnString;
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
con.Open();
System.Data.OleDb.OleDbDataReader dr;
// System.Data.SqlClient.SqlDataReader dr;
//dr = SqlHelper.ExecuteReader(cnString, CommandType.Text, sql);
dr = cmd.ExecuteReader();
cmb.DataSource = dr;
cmb.ValueMember = cmbVal;
cmb.DisplayMember = cmbName;
dr = null;
cmd.Dispose();
con.Close();
con.Dispose();
cmd = null;
con = null;
sql = null;

}
catch (Exception)
{

}
return true;
}
}


Thanks to Bhavesh for his editing.
Enjoy.
Submit your site
Submit your site to listtheweb.com
link