public List<Person> ReadAll() { string queryString = "SELECT * FROM [Table]"; List<Person> pr = new List<Person>(); using (SqlConnection connection = new SqlConnection(connectionString)) { //using (SqlCommand cmd = new SqlCommand("SELECT * FROM [Table]", connection)) //{ SqlCommand cmd = new SqlCommand(queryString, connection); cmd.Connection.Open(); SqlDataReader sdr = cmd.ExecuteReader(); try { while (sdr.Read()) { if (sdr.GetValue(3).ToString() == "") { Woman woman = new Woman(); woman.Id = sdr.GetInt32(0); woman.Name = (string)sdr["Name"]; woman.Beauty = sdr.GetInt32(5); woman.EyeColor = sdr.GetValue(6).ToString(); woman.Smile = sdr.GetValue(7).ToString(); pr.Add(woman); } else { Man man = new Man(); man.Id = sdr.GetInt32(0); man.Name = (string)sdr["Name"]; man.Strength = sdr.GetValue(2).ToString(); man.Age = sdr.GetInt32(3); man.Stamina = sdr.GetInt32(4); pr.Add(man); } } sdr.Close(); sdr.Dispose(); } catch (Exception ex) { var bb = ex.Message; } } return pr; }
public Person Read(int id) { //SqlDataReader dr = null; Person pr = new Person(); using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand("SELECT * FROM [Table] WHERE Id= "+id, connection)) { cmd.Connection.Open(); dr = cmd.ExecuteReader(); while (dr.Read()) { if (dr.GetInt32(3)==0) { Woman woman = new Woman(); woman.Id = dr.GetInt32(0); woman.Name = (string)dr["Name"]; woman.Beauty = dr.GetInt32(5); woman.EyeColor = dr.GetString(6); woman.Smile = dr.GetString(7); pr = woman; } else { Man man = new Man(); man.Id = dr.GetInt32(0); man.Name = (string)dr["Name"]; man.Strength = dr.GetString(2); man.Age = dr.GetInt32(3); man.Stamina = dr.GetInt32(4); pr = man; } } dr.Close(); } } return pr; }