private void Member_Chk(string p1) { Dictionary <string, string> myRecord; using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real)) { if (cmbSel.EditValue.ToString() == "0") { sql.Query = "SELECT login_id FROM domalife.member_master " + "WHERE u_name like '%" + p1 + "%' "; } else if (cmbSel.EditValue.ToString() == "1") { sql.Query = "SELECT login_id FROM domalife.member_master " + "WHERE u_nickname like '%" + p1 + "%' "; } else if (cmbSel.EditValue.ToString() == "2") { sql.Query = "SELECT login_id FROM domalife.member_master " + "WHERE login_id like '%" + p1 + "%' "; } else if (cmbSel.EditValue.ToString() == "3") { sql.Query = "SELECT login_id FROM domalife.member_master " + "WHERE replace(u_cell_num, '-','') = '" + p1.Replace("-", "") + "'"; } myRecord = sql.selectQueryForSingleRecord(); if (myRecord != null && myRecord.Count > 0) { lblID.Text = myRecord["login_id"].ToString(); } } }