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);
}
