Net-informations.com
SiteMap  | About    

C# ODBC Connection

An instance of the OdbcConnection Class in C# is supported the ODBC Data Provider. The OdbcConnection instance takes Connection String as argument and pass the value to the Constructor statement. When the connection is established between C# application and the Data Source the SQL Commands will execute with the help of the Connection Object and retrieve or manipulate data in the database.

  connetionString = "Driver={Microsoft Access Driver (*.mdb)};
  DBQ=yourdatabasename.mdb;";
  cnn = new OdbcConnection(connetionString);

Once the Database activities is over you should be closed the Connection and release the Data Source resources . The Close() method in OdbcConnection Class is used to close the Database Connection.

  cnn.Close();

The Close method rolls back any pending transactions and releases the Connection from the Database connected by the ODBC Data Provider .




using System;
using System.Windows.Forms;
using System.Data.Odbc; 

namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string connetionString = null;
            OdbcConnection cnn ;
            connetionString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=yourdatabasename.mdb;";
            cnn = new OdbcConnection(connetionString);
            try
            {
                cnn.Open();
                MessageBox.Show ("Connection Open ! ");
                cnn.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Can not open connection ! ");
            }
        }
    }
}






net-informations.com (C) 2017    Founded by raps mk
All Rights Reserved. All other trademarks are property of their respective owners.