C#中的ODBC、OLEDB串連

標籤：

原文:C#中的ODBC、OLEDB串連

 

using System;using System.Collections.Generic;using System.Text;using System.Data.Odbc;using System.Data.OleDb;namespace ODBCTest{    class Program    {        static void Main(string[] args)        {            Console.WriteLine("##################################ODBC串連1#############################");            using (OdbcConnection conn = new OdbcConnection("driver={SQL Server};SERVER=127.0.0.1;UID=sa;PWD=Abc123123;DATABASE=booking"))            {                conn.Open();                OdbcCommand cmd = conn.CreateCommand();                cmd.CommandText = "select  * from TEST";                using (OdbcDataReader reader = cmd.ExecuteReader())                {                    Console.WriteLine("欄位數:\t{0}", reader.FieldCount);                    Console.WriteLine("==============資料內容===========");                    while (reader.Read())                    {                        Console.WriteLine("ID: {0}\tTitle: {1}", reader.GetInt32(0).ToString(), reader.GetString(1));                    }                }            }            Console.WriteLine("################################ODBC串連2###############################");            string conString = "Dsn=ggyy1;" + "Uid=sa;" + "Pwd=Abc123123;";//Dsn表示在ODBC建立的使用者資料來源名            OdbcConnection con = new OdbcConnection(conString);            string sql = "select * from TEST"; //stuinfo為使用者資料來源繫結資料庫中的一個表            con.Open();            OdbcCommand com = new OdbcCommand(sql, con);            using (OdbcDataReader reader = com.ExecuteReader())            {                Console.WriteLine("欄位數:\t{0}", reader.FieldCount);                Console.WriteLine("==============資料內容===========");                while (reader.Read())                {                    Console.WriteLine("ID: {0}\tTitle: {1}", reader.GetInt32(0).ToString(), reader.GetString(1));                }            }            Console.WriteLine();            Console.WriteLine("##################################OLEDB串連#############################");            string conString1 = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\test.mdb"; //串連Access資料庫            string sql1 = "select count(*) from TEST";            OleDbConnection con1 = new OleDbConnection(conString1);            con1.Open();            OleDbCommand com1 = new OleDbCommand(sql1, con1);            int i = Convert.ToInt32(com1.ExecuteScalar());            Console.WriteLine(i);            Console.Read();        }    }}

 

C#中的ODBC、OLEDB串連