Tuesday, July 31, 2012

How to connect C# with MS Access database using OledbConnection

1 : Include Files:

using System.Data.OleDb;
using System.Data;

2 : Declare variables that intract with DB

        OleDbConnection conn;
        OleDbCommand comm = new OleDbCommand();
        DataTable dt = new DataTable();
        OleDbDataAdapter da = new OleDbDataAdapter();

3 : Write a method to  Create Connection

private void CreateConnection()
        {
 conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=d:\\sms.mdb");
         if (conn.State == ConnectionState.Closed)
{
                conn.Open();
}
            comm.CommandType = CommandType.Text;
            comm.Connection = conn;
        }
4 : Write your method to function with the DB
I am using to insert some data in DataBase

public int SaveSMS(int number, string SMS)
{
            CreateConnection();
            int result = -1;
   try
     {
     comm.CommandText = "insert into SMSBundle (MobileNo,SMSText) values (@number,@SMS)";
                comm.Parameters.Add(new OleDbParameter("@number", number));
                comm.Parameters.Add(new OleDbParameter("@SMS", SMS));
                result = comm.ExecuteNonQuery();
                comm.Cancel();
                comm.Dispose();
                conn.Dispose();

                return result;
            }
            catch (Exception)
            {
                return -1;
            }
 }

Simple App Test:
This app will simply save a mobile number and an sms in the MS Access DB. Please put the sms.mdb file in D:\ as i have used the static path.







Download:
http://www.mediafire.com/?805s7v12605p53i

No comments:

Post a Comment