110,537
社区成员
发帖
与我相关
我的任务
分享
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = conn;
cmd.CommandText = @"INSERT INTO BUS(RegName) VALUES(@Name);";
MySqlParameter paraRegName = new MySqlParameter("@Name", MySqlDbType.VarChar, 100);
cmd.Parameters.Add(paraRegName);
cmd.Parameters["@Name"].Value = "bus";
int n = cmd.ExecuteNonQuery();
if(n == 1)
{
MessageBox.Show("success");
}
else
{
MessageBox.Show("fail");
}
}
catch (MySqlException ex)
{
string errMsg = "intert data exception.";
errMsg += ex.ToString();
MessageBox.Show(errMsg);
}