侠盗飞车单机破解版:谁会asp.net连接数据库?c#的.加30分!!

来源:百度文库 编辑:查人人中国名人网 时间:2024/05/08 02:21:52
谁会asp.net连接数据库?c#的.加30分!!
与access,mysql,sql-server的,请奉上!

SQLSERVER
using MySql.Data.SqlClient;
SqlConnection(server=ServerName; uid=Uname;password=Upass; database=DatabaseName)

Acces
using MySql.Data.OleDB;
OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DataBasePath)

mysql
using MySql.Data.MySqlClient;
MySqlConnection myConn=new MySqlConnection("server=localhost; user id=snow; password=snow; database=db_test");

SqlConnection conn = new SqlConnection("连接字符串");

SqlDataAdapter sda = new SqlDataAdapter("SQL语句", conn);

conn.Open();

DataSet ds = new DataSet();
sda.Fill(ds);

conn.Close();

SQLSERVER
using MySql.Data.SqlClient;
SqlConnection(server=ServerName; uid=Uname;password=Upass; database=DatabaseName)

Acces
using MySql.Data.OleDB;
OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DataBasePath)

mysql
using MySql.Data.MySqlClient;
MySqlConnection myConn=new MySqlConnection("server=localhost; user id=snow; password=snow; database=db_test");