public void Delete(RetiretagsClass p) { MysqlConnect(); string query = "Delete from `tag` where tag_id=" + p.tag_id; MySqlCommand comm = new MySqlCommand(query); comm.Connection = mysql; mysql.Open(); comm.ExecuteNonQuery(); mysql.Close(); return; }
public RetiretagsClass Detail(string tag_name) { MysqlConnect(); string query = "select * from tag where retire=1 and tag_name='" + tag_name + "'"; MySqlCommand comm = new MySqlCommand(query); comm.Connection = mysql; mysql.Open(); MySqlDataReader dr = comm.ExecuteReader(); dr.Read(); RetiretagsClass x = new RetiretagsClass { tag_id = (int)dr["tag_id"], tag_name = dr["tag_name"].ToString() }; mysql.Close(); return(x); }