-
WCF基础示例代码下载(有宿主有客户端,不错)
WCF分布式开发示例代码包括:1)一个“服务类”WCFService:采用 C#语言编写,实现一个或多个方法,也叫服务契约和操作契约。2)一个“宿主”环境WCFHost:这是一种应用程序域和进程,服务将在该环境中运行。 3)一个“终结点”Client:由客户端用于访问服务。
- 2015-03-11下载
- 积分: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
-
stm32 MQTT
基于freertos实时操作系统实现EC20 MQTT通讯订阅、发布;此代码的使用场景为一秒一次发布GGA数据到远程服务器,同时订阅服务器下发的参数。
- 2021-05-06下载
- 积分:1
-
wpf 动态生成 窗体(不用xaml)示例源码
wpf 动态生成 窗体(不用xaml)示例源码
- 2014-03-25下载
- 积分:1
-
串口CRC16校验
【实例简介】输入相应的字符串,自动生成两个校验码
- 2021-11-16 00:44:01下载
- 积分:1
-
autocad开发基础与实践教程源代码
autocad开发基础与实践教程源代码
- 2015-04-19下载
- 积分:1
-
串口运动控制上位机/C#串口助手源码
C#串口运动控制上位机源码,主要用于运动控制调试,比如在"M "栏输入1000,串口输出M 1000,,在"M-"输入1000,串口输出M-1000;下位机可根据指令进行区别驱动电机方向运动
串口运动控制上位机
└── 马达串口运动控制上位机
├── SerialCommunicate
│ ├── Form1.Designer.cs
│ ├── Form1.cs
│ ├── Form1.resx
│ ├── Program.cs
│ ├── Properties
│ │ ├── AssemblyInfo.cs
│ │ ├── Resources.Designer.cs
│ │ ├── Resources.resx
│ │ ├── Settings.Designer.cs
│ │ └── Settings.settings
│ ├── SerialCommunicate.csproj
│ ├── bin
│ │ ├── Debug
│ │ │ ├── SerialCommunicate.exe
│ │ │ ├── SerialCommunicate.pdb
│ │ │ ├── SerialCommunicate.vshost.exe
│ │ │ └── SerialCommunicate.vshost.exe.manifest
│ │ └── Release
│ │ ├── SerialCommunicate.exe
│ │ ├── SerialCommunicate.pdb
│ │ ├── SerialCommunicate.vshost.exe
│ │ └── SerialCommunicate.vshost.exe.manifest
│ └── obj
│ ├── Debug
│ │ ├── DesignTimeResolveAssemblyReferences.cache
│ │ ├── DesignTimeResolveAssemblyReferencesInput.cache
│ │ ├── SerialCommunicate.Form1.resources
│ │ ├── SerialCommunicate.Properties.Resources.resources
│ │ ├── SerialCommunicate.csproj.FileListAbsolute.txt
│ │ ├── SerialCommunicate.csproj.GenerateResource.Cache
│ │ ├── SerialCommunicate.csprojResolveAssemblyReference.cache
│ │ ├── SerialCommunicate.exe
│ │ ├── SerialCommunicate.pdb
│ │ └── TempPE
│ └── Release
│ ├── 3ed801191daeeafe4f32720599873cc71f6b.png
│ ├── DesignTimeResolveAssemblyReferences.cache
│ ├── DesignTimeResolveAssemblyReferencesInput.cache
│ ├── QIcon Changer.exe
│ ├── SerialCommunicate.Form1.resources
│ ├── SerialCommunicate.Properties.Resources.resources
│ ├── SerialCommunicate.csproj.FileListAbsolute.txt
│ ├── SerialCommunicate.csproj.GenerateResource.Cache
│ ├── SerialCommunicate.csprojResolveAssemblyReference.cache
│ ├── SerialCommunicate.exe
│ ├── SerialCommunicate.pdb
│ └── TempPE
├── SerialCommunicate.sln
└── SerialCommunicate.v11.suo
11 directories, 40 files
- 2021-08-15 00:31:13下载
- 积分:1
-
c# 将汉字转换成带声调的方法 示例代码
c# 将汉字转换成带声调的方法 示例代码
- 2015-01-03下载
- 积分:1
-
计算不规则格网土方量计算 Calculation of irregular grid earthwork calculation
完整的VS项目,采用VS2017编写; 2.C#语言开发; 3.可以构建不规则三角网,并进行土方计算; 4.采用可视化读文件方式,并用表格显示; 5.计算完成后实时绘制三角网; 6.可以输出TIN的点、边、三角形信息和土方量。
- 2021-05-06下载
- 积分:1
-
调用微信公众号消息推送
在微信公众号中对指定的已关注的用户进行消息推送
- 2019-07-17下载
- 积分:1