-
完整的四人网络麻将游戏
实现了一个完整的四人网络麻将游戏,该程序集服务器与客户端功能与一体。本章主要介绍了非对等的网络服务功能的建立,传输信息的序列化,建立虚拟的三维空间,绘制图形和显示位图,在内存中创建位图和绘制图形等。(achieve a complete network of four mahjong games, the procedures set server and client functions and integration. This chapter introduces the non-reciprocal network services established, the sequence of transmission of information, the establishment of a virtual three-dimensional space, drawing and display bitmap in memory to create bitmap graphics and mapping.)
- 2005-06-20 16:32:22下载
- 积分:1
-
51单片机通信参考程序
NRF24L01无线通信,51单片机通信参考程序(24l01 wireless comunication)
- 2020-06-20 02:20:01下载
- 积分: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
-
A great list of tasks to be done and completed
Windows窗体应用程序添加新任务,重新排列添加的任务。任务删除是一个有趣且非常有用的软件源代码,它在鼠标单击和完成任务之间发送分配的任务。
- 2022-04-16 03:51:27下载
- 积分:1
-
Delaunay
说明: 基于opencv的Deluanay抛分算法,可以实现点到面的扩散(Opencv of Deluanay throw points based algorithms, can point to the proliferation of surface)
- 2011-03-23 10:10:38下载
- 积分:1
-
c++希尔排序
希尔排序(Shell Sort)是插入排序的一种。也称缩小增量排序,是直接插入排序算法的一种更高效的改进版本。希尔排序是非稳定排序算法。该方法因DL.Shell于1959年提出而得名。
希尔排序是把记录按下标的一定增量分组,对每组使用直接插入排序算法排序;随着增量逐渐减少,每组包含的关键词越来越多,当增量减至1时,整个文件恰被分成一组,算法便终止。
- 2022-06-29 12:34:05下载
- 积分:1
-
Untitled3
HEED协议对LEACH的改进代码,分簇速度快,生命周期延长。(Improved code HEED protocol LEACH clustering speed, longer life cycle.)
- 2021-05-07 08:58:36下载
- 积分:1
-
OpenBCI脑电波采集代码
OpenBCI脑电ADS1299采集代码,PIC芯片驱动,c++代码管理,思路清晰一目了然,可以帮助开发脑电波采集系统的人员参考。内涵加速度计、陀螺仪驱动,SD卡驱动,还有蓝牙驱动,非常方便的与上位机软件进行数据交互。适用于机器人、人工智能、人体工效学的研究与开发。结合血氧饱和度的采集可以更好的反应人脑的意念响应。
- 2023-07-16 17:00:03下载
- 积分:1
-
SAE-J1699-1
sea j1699-1 介绍OBD测试规则的一个文档(sea j1699-1 to introduce the rules of OBD testing a document)
- 2009-06-26 17:06:35下载
- 积分:1
-
DHT11
DHT11数字温湿度传感器是一款含有已校准数字信号输出的温湿度复合传感器,它应用专用的数字模块采集技术和温湿度传感技术,确保产品具有极高的可靠性和卓越的长期稳定性。传感器包括一个电阻式感湿元件和一个NTC测温元件,并与一个高性能8位单片机相连接
- 2022-06-02 11:50:05下载
- 积分:1