上海迈凯轮p1王子光:谁会asp.net连接数据库?c#的.加30分!!

来源:百度文库 编辑:中科新闻网 时间:2024/05/05 10:46:58
谁会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");