public string SelectEmployees() { string str = ""; dbConnection.Close(); Emploeey row = new Emploeey(); command = dbConnection.CreateCommand(); command.CommandText = "SELECT * FROM Employees"; command.CommandType = CommandType.Text; dbConnection.Open(); var reader = command.ExecuteReader(CommandBehavior.SingleResult); while (reader.Read()) { row.IDEmpl = reader[0].ToString(); row.FIO = reader[1].ToString(); row.Login = reader[2].ToString(); row.IDDep = reader[3].ToString(); row.Position = reader[4].ToString(); row.PhoneEmpl = reader[5].ToString(); row.E_mail = reader[6].ToString(); str += reader[0].ToString() + "|" + reader[1].ToString() + "|" + reader[2].ToString() + "|" + reader[3].ToString() + "|" + reader[4].ToString() + "|" + reader[5].ToString() + "|" + reader[6].ToString() + "*"; } return(str.Substring(0, str.Length - 1)); }
public Array SelectEmployees() { dbConnection.Close(); ArrayList tabl = new ArrayList(); Emploeey row = new Emploeey(); command = dbConnection.CreateCommand(); command.CommandText = "SELECT * FROM Emploeeys"; command.CommandType = CommandType.Text; dbConnection.Open(); var reader = command.ExecuteReader(CommandBehavior.SingleResult); while (reader.Read()) { row.IDEmpl = reader[0].ToString(); row.FIO = reader[1].ToString(); row.Login = reader[2].ToString(); row.IDDep = reader[3].ToString(); row.Position = reader[4].ToString(); row.PhoneEmpl = reader[5].ToString(); row.E_mail = reader[6].ToString(); tabl.Add(row); } return(tabl.ToArray()); }