Hello,
I have the same problem, my solution was to change @ to ? like:
protected void Button1_Click(object sender, EventArgs e)
{
MySqlConnection conx;
conx = new MySqlConnection("server=localhost; database=pt; user id=root;");
MySqlCommand SimpanAdmin = new MySqlCommand("insert into adminPT (nama,katasandi) Values (?A,?AB)", conx);
SimpanAdmin.Parameters.Add("?A", MySqlDbType.VarChar,50).Value = TextBox1.Text;
SimpanAdmin.Parameters.Add("?AB", MySqlDbType.VarChar,45).Value = TextBox2.Text;
chy.Text = "Proses Menyimpan Berhasil...!!!";
try
{
SimpanAdmin.Connection.Open();
SimpanAdmin.ExecuteNonQuery();
SimpanAdmin.Connection.Close();
}
catch
{
chy.Text = "Proses Menyimpan Gagal...!!!";
}
}
HTH