/// <summary> /// Looking for a Member in CardTable Table from the Database /// </summary> /// <param Column Name="Para"></param> /// <param Column Value="Value"></param> public MemberClass FindMember(object Para, object Value) { string FindQuery; if ((string)Para == "Name") { FindQuery = FindMemQuery + $"[{Para}] like @ParamVal " + $"or [{Para}] like @ParamVal + CHAR(10) +'%' " + $"or [{Para}] like @ParamVal + CHAR(13) +'%' "; } else { FindQuery = FindMemQuery + $"[{Para}] = @ParamVal "; } MemberClass Member = new MemberClass(); using (ServerConnect = new SqlConnection(connectionString)) using (SqlCommand command = new SqlCommand(FindQuery, ServerConnect)) { ServerConnect.Open(); try { command.Parameters.AddWithValue("@ParamVal", Value); SqlDataReader rd; rd = command.ExecuteReader(); if (rd.Read()) { object[] BufferValue = new object[13]; rd.GetValues(BufferValue); Member.ReadMember(BufferValue); ServerConnect.Close(); return(Member); } else { ServerConnect.Close(); return(null); } } catch (Exception e) { ServerConnect.Close(); MessageBox.Show(e.ToString()); Application.Exit(); return(null); } } }