C#連結MySQL

標籤：

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;using MySql.Data.MySqlClient;namespace MySQLtest{    public partial class Form1 : Form    {        public Form1()        {            InitializeComponent();        }        private void btnConnect_Click(object sender, EventArgs e)        {            string strcn = "Server=127.0.0.1;User ID=root;Password=mysql;Database=student;CharSet=gbk;";            MySqlConnection cn = new MySqlConnection(strcn);//執行個體化連結            cn.Open();//開啟串連            MySqlCommand cmd = cn.CreateCommand();            /************************************************            cmd.CommandText = "insert stu (sno,sname,sclass) values(‘20161‘,‘tt‘,‘class1‘)";//SQL插入資料            cmd.CommandText = "insert stu values(‘20162‘,‘ll‘,‘class3‘)";            cmd.CommandText = "delete from stu";//刪除資料            cmd.CommandText = "delete from stu where sname=‘ll‘";            cmd.CommandText = "update stu set sclass=‘class2‘ where sclass=‘class3‘";//修改資料            ************************************************/            cmd.CommandType = CommandType.Text;            int i = cmd.ExecuteNonQuery();            cn.Close();//關閉串連        }    }}

上課學的C#連結Sql Server 因為一直用的MySQL 自己把它改成了C#連結MySQL

C#連結MySQL