王者荣耀投降截图:谁会asp.net连接数据库?c#的.加30分!!
来源:百度文库 编辑:神马品牌网 时间:2024/05/11 16:36:19
与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");