ساختن جدول
CREATE TABLE Users(
id INT NOT NULL AUTO_INCREMENT,
name VarCHAR(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (id)
);
کانکشن استرینگ
string ConnectionString = "Server=localhost;Database=ABC;Uid=root;Pwd=12345; charset=utf8;";
اینزرت
private void button4_Click(object sender, EventArgs e)
{
MySqlConnection Con = new MySqlConnection(ConnectionString);
MySqlCommand cmd = new MySqlCommand("insert into users values(NULL,'مهدی')", Con);
Con.Open();
cmd.ExecuteNonQuery();
Con.Close();
}
سلکت
private void button5_Click(object sender, EventArgs e)
{
MySqlConnection Conn = new MySqlConnection(ConnectionString);
MySqlCommand Cmd = new MySqlCommand("Select * from users", Conn);
Conn.Open();
MySqlDataReader R = Cmd.ExecuteReader();
while (R.Read())
MessageBox.Show(R[0].ToString() + " --- " + R[1].ToString());
Conn.Close();
}