中连接数据库的语句

更新时间:02-03 教程 由 悦缘 分享
中连接数据库的语句?

//Access

using System.Data;

using System.Data.OleDb;

connString ="Provider =Microsoft.Jet.OleDb.4.0;Data Source=" + System.Web.HttpContext.Current.Server.MapPath("~/App_Data/MyDatabase.mdb");

//SQL server

using System.Data;

using System.Data.SqlClient;

//SQL2005

connString="Data Source=zhou\\sql2005;Initial Catalog=AspNetStudy;Persist Security Info=True;User ID=sa;Password=123456");

//SQL2008

connString = @"server=LENOVO-AA\MYDATABASE;database=Database;Trusted_Connection=True";

//MySQL

using MySQLDriverCS;

using System.Net;

using System.Text;

using CoreLab.MySql;

using System.Data.Odbc;

using MySql.Data.MySqlClient;

MySQLConnection DBConn = new MySQLConnection(new MySQLConnectionString("localhost","mysql","root","",3306).AsString);

connString = "User Id=root;Host=localhost;Database=qing;password=qing";

//Sybase

Provider=Sybase.ASEOLEDBProvider.2;Initial Catalog=数据库名;User ID=用户名;Data Source=数据源;Extended Properties="";Server Name=ip地址;Network Protocol=Winsock;Server Port Address=5000;

//Oracle

using System.Data;

using System.Data.OracleClient;

connString="Data Source=sky;user=system;password=manager;";

//IBM DB2

connStri = "Driver={IBM DB2 ODBC DRIVER};Database=sample;hostname=192.168.1.46;port=50000;protocol=TCPIP; uid=admin; pwd=admin";

声明:关于《中连接数据库的语句》以上内容仅供参考,若您的权利被侵害,请联系13825271@qq.com
本文网址:http://www.25820.com/tutorial/14_2210383.html