c#连接mysql

string MysqlConn = "Server=localhost;Database=test;Uid=root;Pwd=123456;";
MySqlConnection connection = new MySqlConnection(MysqlConn);
connection.Open();

MySqlCommand cmd;
cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
//cmd.CommandText = "INSERT INTO news (title,slug,text) values('titlevalue','titlevalue','titlevalue')";
string title = "titlevalue1";
string slug = "slugvalue1";
string text = "textvalue1";
cmd.CommandText = string.Format("INSERT INTO news (title,slug,text) values('{0}','{1}','{2}')", title, slug, text);
cmd.ExecuteNonQuery();
*/

/*
//第二种方式 插入
//连接数据库 //mysql 数据库有点特殊 参数要用?
string MysqlConn = "Server=localhost;Database=test;Uid=root;Pwd=123456";
MySqlConnection connection = new MySqlConnection(MysqlConn);
connection.Open();


MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "INSERT INTO news (title,slug,text) values(?title,?slug,?text)";
//也可以这样 MySqlCommand cmd = new MySqlCommand(sql,connection); //类似于php中的写法 query($sql,$conn);

cmd.Parameters.AddWithValue("?title","title5");
cmd.Parameters.AddWithValue("?slug", "slug5");
cmd.Parameters.AddWithValue("?text", "text5");
cmd.ExecuteNonQuery();
*/

/*
// 查 数据
string MysqlConn = "Server=localhost;Database=test;Uid=root;Pwd=123456";
MySqlConnection connection = new MySqlConnection(MysqlConn);
connection.Open();

MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "SELECT * FROM news";

MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
DataSet MyDataSet = new DataSet();

adapter.Fill(MyDataSet);

Console.WriteLine(MyDataSet.Tables[0].Rows[0]["title"].ToString());
*/

/*
// 删数据
string MysqlConn = "Server=localhost;Database=test;Uid=root;Pwd=123456";
MySqlConnection connection = new MySqlConnection(MysqlConn);
connection.Open();

MySqlCommand cmd = connection.CreateCommand();
//int id = 1;
cmd.CommandText = "delete from news where id = ?id";
cmd.Parameters.AddWithValue("?id", 1);

cmd.ExecuteNonQuery();
*/
/*
//更新
string MysqlConn = "Server=localhost;Database=test;Uid=root;Pwd=123456";
MySqlConnection connection = new MySqlConnection(MysqlConn);
connection.Open();

MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "update news set title=?t where id=?i";
cmd.Parameters.AddWithValue("?i", 2);
cmd.Parameters.AddWithValue("?t", "newTitle");
cmd.ExecuteNonQuery();
**/

/*
//Mssql连接存储过程 用语句的应该和 mysql 的操作相似
string MssqlConn = "Data Source=192.168.208.200,2012;Initial Catalog=NCMPI;Persist Security Info=False;User ID=sa;Password=pwd@123;Pooling=True;Min Pool Size=20;Max Pool Size=100;Application Name=AutoNetCallback";
SqlConnection connection = new SqlConnection(MssqlConn);
connection.Open();

SqlCommand cmd = new SqlCommand("NCMPI.业务_旧查询掉单",connection);
cmd.CommandType = CommandType.StoredProcedure;

SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet MyDataSet = new DataSet();
adapter.Fill(MyDataSet);

Console.WriteLine(MyDataSet.Tables[0].Rows[0]["UPMP订单号"].ToString());
*/