-
gcji
c Language压缩库,c语言压缩库()
- 2018-03-16 21:11:16下载
- 积分：1
-
C#连接数据库（SQL Server,MySQL,Microsoft Access,DB2,Oracle）连接字符串
C#/.NET项目开发过程中，特别是中大型的项目，跟数据库打交道那是再正常不过的事情了。数据库可以帮助我们保存和管理数据。C#/.NET的项目中，我们也可以使用不同的数据库。
那么，我们今天就来总结整理一下C#/.NET的连接各类主流数据库（SQL Server,MySQL,Microsoft Access,DB2,Oracle）的连接字符串。
一、C#/.NET连接Microsoft SQL Server
1. 使用ODBC数据库连接
// ODBC标准连接
using System.Data.Odbc;
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = "Driver={SQL Server}; Server=ServerName; DataBase=DataBaseName; Uid=UserName; Pwd=password";
conn.Open();
// ODBC受信任的连接
using System.Data.Odbc;
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = "Driver={SQL Server}; Server=ServerName; DataBase=DataBaseName; Uid=admin; Pwd=password";
conn.Open();
// 或者
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = "Driver={SQL Server}; Server=ServerName; DataBase=DataBaseName; Trusted_Connection=Yes;";
2.使用OLEDB
// OleDb标准连接
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Driver=SQLOLEDB; Data Source=ServerName; Initial Catalog=DataBaseName; User id=UserName; Password=Secret;";
conn.Open();
// OleDb受信任的连接
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Driver=SQLOLEDB; Data Source=ServerName; Initial Catalog=DataBaseName; Integrated Security=SSPI;";
conn.Open();
3.使用.Net DataProvider
// .NET DataProvider标准连接
using System.Data.SqlClient;
SqlConnection conn = new SqlDbConnection();
conn.ConnectionString ="Data Source=ServerName; Initial Catalog=DataBaseName; User id=UserName; Password=Secret;";
conn.Open();
Data Source=DESKTOP-AC9DHQ6;Initial Catalog=MyKTV;Persist Security Info=True;User ID=sa;Password=mdg456123
// .NET DataProvider受信任连接
using System.Data.SqlClient;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=ServerName; Initial Catalog=DataBaseName; Integrated Security=SSPI;";
conn.Open();
二、C#/.NET连接Microsoft Access
1.使用ODBC连接
// ODBC标准连接
using System.Data.Odbc;
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)}; Dbq=c:myPathmyDb.mdb; Uid=Admin; Pwd=;password";
conn.Open();
// ODBC工作组(Workgroup)连接
using System.Data.Odbc;
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)}; Dbq=c:myPathmyDb.mdb; SystemDb=c:myPathmyDb.mdw;";
conn.Open();
2.使用OLEDB连接
// 使用OleDb的Jet标准安全连接
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:mypathmyDb.mdb; User id=admin;Password=password";
conn.Open();
// 使用OleDb的Jet System Database连接
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:mypathmyDb.mdb; System Database=c:mypathmyDb.mdw";
conn.Open();
三、C#/.NET连接MySQL数据库
1.使用ODBC数据源连接
// ODBC使用MyODBC Driver的远程数据库连接
using System.Data.Odbc;
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = "Driver={MySql}; Server=192.168.0.10; Option=131072; Port=3306; Stmt=; DataBase=DataBaseName; Uid=UserName; Pwd=password;" ;
conn.Open();
2.使用OLEDB连接
// OleDb标准连接
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Provider=MySqlProv; Data Source=ServerName; User id=UserName; Password=Password";
conn.Open();
四、C#/.NET连接DB2数据库
1.使用ODBC连接
// 不带DSN的ODBC连接
using System.Data.Odbc;
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = "Driver={IBM DB2 ODBC DRIVER};DataBase=DataBaseName; HostName=ServerName; Protocol=TCPIP;Port=PortNumber;Uid=UserName;Pwd=Secret";
conn.Open();
2.使用OLEDB连接
// OleDb微软官方驱动
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Driver=DB2OLEDB; Network Transport Library=TCPIP; Network Address=xxx.xxx.xxx.xxx; Package Collection=CollectionName; Initial Catalog=DataBaseName; User id=UserName; Password=Secret;";
conn.Open();
// OleDb IBM 驱动
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Driver=IBMDADB2; DataBase=DataBaseName; HostName=ServerName; Protocol=TCPIP; Port=PortNumber; Uid=UserName; Pwd=Secret;";
conn.Open();
3.使用.Net DataProvider第三方驱动
// 来自IBM的.NET DataProvider
using IBM.Data.DB2;
Db2Connection conn = new Db2Connection();
conn.ConnectionString = "DataBase=DataBaseName;Uid=UserName;Pwd=Secret";
conn.Open();
五、C#/.NET连接Oracle数据库
1.使用ODBC连接
// ODBC 微软的官方驱动
using System.Data.Odbc;
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = "Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=UserName;Pwd=Secret;";
conn.Open();
// ODBC Oracle的驱动
using System.Data.Odbc;
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = "Driver={Oracle ODBC Driver};Dbq=myDataBase;Uid=UserName;Pwd=Secret;";
conn.Open();
2.使用OLEDB连接
// OleDb:Oracle驱动的标准连接
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Driver=OraOLEDB.Oracle;Data Source=ServerName;User id=UserName;Password=Secret;";
conn.Open();
// OleD:Oracle驱动的受信任连接
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Driver=OraOLEDB.Oracle;Data Source=ServerName;OSAuthent=1;";
conn.Open();
// 或者写成
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Driver=OraOLEDB.Oracle;Data Source=ServerName;User id=admin;Password=pwd";
conn.Open();
- 2021-08-07 00:31:00下载
- 积分：1
-
Laserscan
基本STC51单片机的PWM双直流电流扫描激光灯，通过控制两电机的不同速度比来实现多种图案的扫描显示。(Basic STC51 MCU PWM double dc current scanning laser, by controlling the different speed ratios of the two motor to realize the scans showed a variety of design.)
- 2013-08-04 21:01:51下载
- 积分：1
-
leetcode-cpp
LeetCode Problem Solving: It is suitable for beginners who are looking for jobs, brushing questions and preparing for ACM algorithm competition.
- 2019-02-18 19:43:31下载
- 积分：1
-
HackerProgramming
黑客编程技巧大全，非常用值得学习的一本书。(Hacker programming skills Daquan, very much worth learning to use a book.)
- 2009-10-09 17:35:38下载
- 积分：1
-
温度及ID功能测试程序
max30102 温度检测代码 基于51单片机实现(Temperature detection)
- 2020-11-13 16:49:42下载
- 积分：1
-
MyDoorFirmware_V2_IAP
说明： 基于STM32F091，用SPI接口读取TF卡内部升级文件，进行IAP升级(STM32F091, SPI, TF card, IAP)
- 2019-12-19 17:50:19下载
- 积分：1
-
daozha
停车厂系统 道闸板控制程序 应用在实际工程中(Road gate control program)
- 2011-08-18 21:20:51下载
- 积分：1
-
Unity插件：PDF Renderer v5.15
【实例简介】
unity读取PDF文件的插件，有需要的话超级好用
- 2021-07-03 00:31:10下载
- 积分：1
-
Demo_CR95HF
在工作中曾完成的一个NFC读卡器，
主要使用的ST公司的新推出的CR95HF芯片，做板测试已OK。
对于从事NFC开发的人员绝对是一种值得备用的资料。
（附件提供原理图，CR95HF编程手册，驱动CR95HF的C源代码，另包含有 对双接口芯片M24LR64的驱动）
CR95HF芯片有如下特点：
标准频率：13.56-MHz
支持多协议：ISO/IEC 14443 A and B，ISO/IEC 15693，ISO/IEC 18092
提供2种标准接口： SPI 和 UART 。
只需简单的7条指令：
(Work was done in a NFC reader, the main use of the ST' s new CR95HF chip board test has to do OK. Personnel engaged in the development of NFC is definitely a worthy alternative information. (Annex provides schematics, CR95HF programming manual, driver CR95HF the C source code, and the other contains the dual interface chip M24LR64 driver) CR95HF chip has the following characteristics: standard frequency :13.56-MHz multi-protocol support: ISO/IEC 14443 A and B, ISO/IEC 15693, ISO/IEC 18092 provides two standard interfaces: SPI and UART. 7 simple instructions:)
- 2021-03-25 18:59:14下载
- 积分：1
