-
Chance-constrained-programming
关于机会约束规划的一个小算例,利用蒙特卡洛仿真实现(a small case about Chance-constrained programming，used Monte Carlo Simulation)
- 2020-11-18 16:19:39下载
- 积分：1
-
STM32 c8t6按键
首先，上拉电阻是为了保证在没有信号输入的时候，IO口保持高电平，若按键为低电平有效，则没有信号的时候，IO应呈现高电平，所以，此处应设置为上拉输入。
同理，下拉电阻是为了保证在没有信号输入的时候，IO口保持低电平，若按键为高电平有效，则没有信号的时候，IO应呈现低电平
- 2023-04-21 17:40:03下载
- 积分：1
-
LiveZilla_3.1.8.6
免注册QQ/MSN号码,直接在网页上聊天/通话/视频,最佳在线客服.(Live Support)
- 2010-05-18 17:35:55下载
- 积分：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
-
WCFEfficencyTest
一个wcf通讯的例子程序一个wcf通讯的例子程序(WCF example of a communication procedure of a WCF example of communication procedures)
- 2009-02-17 16:44:23下载
- 积分：1
-
销售管理
销售管理与 C# microsoft visual C#。至少 100 个字符。请尽你所能描述您的项目的详细信息。更好的内容将为您获得更多的分数）
- 2023-08-26 14:55:05下载
- 积分：1
-
LCD_DISP
液晶驱动的有需要的朋友可以下载查阅学习和了解(LCD driver in need of a friend can download access to learning and understanding of the)
- 2009-11-09 18:47:06下载
- 积分：1
-
asterisk_update
说明： ASTERISK 更新文件，有空的可以看看(ASTERISK updates files, you can see when you are free)
- 2020-06-20 07:00:01下载
- 积分：1
-
EmbeddedProject1
说明： 基于VS2019+VisualGDB的STM32F10X 项目模板
编程语言：C++11
调试方式：Jlink(STM32F10X Project Template Based on VS2019+Visual GDB
Programming language: C++ 11
Debugging: Jlink)
- 2020-06-18 22:00:01下载
- 积分：1
-
一个用c#实现的计算器源码,实现了计算器的常见功能,本程序侧重于让大家了解各种逻辑关系和常见算法,故界面较为粗糙,还请大家谅解...
一个用c#实现的计算器源码,实现了计算器的常见功能,本程序侧重于让大家了解各种逻辑关系和常见算法,故界面较为粗糙,还请大家谅解-A used c# Realize calculator source code to achieve a common calculator functions, this program focuses on allowing everyone to understand the logic of relations and the common algorithm, so the interface is more rough, also requested the U.S. understanding
- 2022-05-27 05:04:51下载
- 积分：1
