CSharp.Net-Informations.com
   Home      .Net Framework      VB.NET      C#                                                                      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 .

         C# Source Code Download           Print Source Code
         C# ODBC Connection - Download
        
C# Tutorial

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 ! ");
            }
        }
    }
}



C# ADO.NET data Providers Related Contents
*     C# ADO.NET Connection
*     C# SQl Server Connection
*     C# OLEDB Connection
*     C# ADO.NET Command
*     C# ADO.NET SqlCommand - ExecuteNonQuery
*     C# ADO.NET OleDbCommand - ExecuteNonQuery
*     C# ADO.NET SqlCommand - ExecuteScalar
*     C# ADO.NET OleDbCommand - ExecuteScalar
*     C# ADO.NET SqlCommand - ExecuteReader
*     C# ADO.NET OleDbCommand - ExecuteReader
*     C# ADO.NET DataReader
*     C# ADO.NET SqlDataReader
*     C# ADO.NET OleDbDataReader
*     C# Multiple Result Sets
*     C# Table Schema from SqlDataReader
*     C# Table Schema from OleDbDataReader
*     C# ADO.NET DataAdapter
*     C# ADO.NET SqlDataAdapter
*     C# ADO.NET OleDbDataAdapter
*     C# ExecuteReader and ExecuteNonQuery


   Home      VB.NET      C#
CSharp Related Topics
*     An overview of Microsoft CSharp
*     C# Language Tutorial
*     C# Statements Tutorial
*     C# Collection Tutorial
*     C# String Tutorial
*     C# File Operations Tutorial
*     C# Excel Tutorial
*     C# Crystal Reports Tutorial
*     CSharp Communication Tutorial
*     C# Ado.Net Tutorial and Source Code
*     C# ADO.NET data Providers Tutorial
*     C# Dataset Tutorial
*     C# DataAdapater Tutorial
*     Csharp DataView Tutorial
*     Csharp Remoting Tutorial
*     C# XML Tutorial
*     C# DataGridView Tutorial
   Home      VB.NET      C#
More Source Code :   
Mail to :  feedback@net-informations.com
  |  Home   |  VB.NET   |  C#   |  SiteMap   |  Terms of Use   |  About   |
net-informations.com (C) 2010
All Rights Reserved. All other trademarks are property of their respective owners.