c#sql连接mysql_C#连接MySQL数据库和本地SQL Server(.mdf)数据库文件

1.MySQL

MySqlConnection conn = new MySqlConnection();

string connStr = "Server=localhost;User

Id=root;Password=mysql;Persist Security

Info=True;Database=test";

conn.ConnectionString = connStr;

string cmdStr = "select * from Categories_mysql";

MySqlDataAdapter myadp = new MySqlDataAdapter(cmdStr, conn);

DataSet ds = new DataSet();

myadp.Fill(ds);

conn.Close();

dataGridView1.DataSource = ds.Tables[0];

2.SQL Server

string connStr2 = @"Data

Source=.\SQLEXPRESS;Integrated

Security=SSPI;AttachDbFileName=E:\fillblank\fillblank\AppData\NORTHWND.mdf;User

Instance=true";

SqlConnection conn2 = new SqlConnection(connStr2);

conn2.Open();

string cmdStr2 = "Select * From Categories";

SqlDataAdapter sqladp = new SqlDataAdapter(cmdStr2,conn2);

DataSet ds2 = new DataSet();

sqladp.Fill(ds2);

conn2.Close();

dataGridView2.DataSource = ds2.Tables[0];