东台安丰镇导航:谁会asp.net连接数据库?c#的.加30分!!

来源:百度文库 编辑:高考问答 时间:2024/05/10 04:31:47
谁会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");