-
WPF 画图示例 以及多个图形重复利用示例源码下载
Drawing Shapes 绘制各种图形示例
- 2013-10-03下载
- 积分:1
-
NET winform企业ERP管理系统
ET winform企业ERP管理系统完整源码 本系统属于中小型企业ERP管理系统,可以对中小型生产企业或商业企业进行有效管理。通过本系统可以达到以下目标: 灵活的录入数据,使信息传递方便、快捷; 系统采用人机交互方式,界面美观友好,操作灵活方便,业务流程控制严谨,数据存储安全可靠; 严格按操作功能来分配权限; 严格控制业务流程,主动向用户提示业务流程信息; 各种单据的最终确认,需要具有审核权限的人员进行审核操作; 客户分析采用图形化显示,直观明了; 实现各种综合查询和模糊查询; 实现企业客户及其内部资源的信息集成化管理; 对用户输入的数据,进行严格的数据检验,尽可能避免人为错误; 系统最大限度地实现了易维护性和易操作性。 登陆帐号mr 密码mrsoft V0.2 优化了代码 修复了若干问题
- 2014-10-17下载
- 积分:1
-
C#加密文件
C#加密文件
- 2013-10-31下载
- 积分:1
-
制作安装软件的卸载程序
利用C#制作的卸载方式,将对应的打包好的安装程序id替换之后,就可以变成专用的卸载程序
- 2014-07-09下载
- 积分:1
-
C# 虚拟路由助手、虚拟wifi 源码下载
C# 虚拟路由助手、虚拟wifi 源码下载
- 2015-05-31下载
- 积分:1
-
c#高精度计时器(精确到1毫秒)
该例子实现了高精度定时器功能,最高定时精度为1ms
- 2019-07-13下载
- 积分:1
-
简单三层+EF
简单三层+EF
- 2014-04-14下载
- 积分:1
-
c++猜数小游戏源码(入门级)
c++猜数小游戏源码(入门级)
- 2020-04-19下载
- 积分:1
-
C#实现Socket通讯Demo
c#通过Socket实现图片、文件和文字的通讯。
private void button1_Click(object sender, EventArgs e)
{
try
{
server = TxStart.startServer(int.Parse(textBox_port.Text));
server.AcceptString = new TxDelegate(acceptString);
server.AcceptByte = new TxDelegate(acceptBytes);
server.Connect = new TxDelegate(connect);
server.dateSuccess = new TxDelegate(dateSuccess);
server.Disconnection = new TxDelegate(disconnection);
server.EngineClose = new TxDelegate(engineClose);
server.EngineLost = new TxDelegate(engineLost);
//server.BufferSize=12048;
//server.FileLog = "C:\test.txt";
server.StartEngine();
this.button1.Enabled = false;
this.button2.Enabled = true;
this.button3.Enabled = true;
}
catch (Exception Ex) { MessageBox.Show(Ex.Message); }
}
///
/// 发送按钮
///
///
///
private void button2_Click(object sender, EventArgs e)
{
try
{
IPEndPoint client = (IPEndPoint)this.comboBox1.SelectedItem;
if (client == null)
{
MessageBox.Show("没有选中任何在线客户端!");
return;
}
if (!this.server.clientCheck(client))
{
MessageBox.Show("目标客户端不在线!");
return;
}
server.sendMessage(client, textBox_msg.Text);
}
catch (Exception Ex) { MessageBox.Show(Ex.Message); }
}
///
/// 下面显示的
///
///
///
private void show(IPEndPoint ipEndPoint, string str)
{
label_zt.Text = ipEndPoint.ToString() ":" str;
label_all.Text = "当前在线人数:" this.server.ClientNumber.ToString();
}
///
/// 当组合框按下的时候
///
///
///
private void comboBox1_DropDown_1(object sender, EventArgs e)
{
try
{
List list = this.server.ClientAll;
this.comboBox1.DataSource = list;
}
catch { }
}
///
/// 关闭客户端的按钮
///
///
///
private void button3_Click_1(object sender, EventArgs e)
{
IPEndPoint client = (IPEndPoint)this.comboBox1.SelectedItem;
if (client == null)
{
MessageBox.Show("没有选中任何在线客户端!");
return;
}
if (!this.server.clientCheck(client))
{
MessageBox.Show("目标客户端不在线!");
return;
}
server.clientClose(client);
}
#endregion
- 2021-08-22 00:31:02下载
- 积分: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