public List <CalculatriceBean> ObtenirListeCalculatrice() { SqlConnection cnn = null; var connetionString = Properties.Settings.Default.dbConnectionString; var calculatrices = new List <CalculatriceBean>(); cnn = new SqlConnection(connetionString); const string sql = "SELECT * FROM Calculatrice c "; try { cnn.Open(); var command = new SqlCommand(sql, cnn); var dataReader = command.ExecuteReader(); while (dataReader.Read()) { var calcu = new CalculatriceBean { NoCalculatrice = int.Parse(dataReader.GetValue(0).ToString()), Modele = dataReader.GetValue(1).ToString() }; calculatrices.Add(calcu); } dataReader.Close(); command.Dispose(); cnn.Close(); } catch (Exception ex) { // MessageBox.Show("Can not open connection ! "); } return(calculatrices); }
public List<CalculatriceBean> ObtenirListeCalculatrice() { SqlConnection cnn = null; var connetionString = Properties.Settings.Default.dbConnectionString; var calculatrices = new List<CalculatriceBean>(); cnn = new SqlConnection(connetionString); const string sql = "SELECT * FROM Calculatrice c "; try { cnn.Open(); var command = new SqlCommand(sql, cnn); var dataReader = command.ExecuteReader(); while (dataReader.Read()) { var calcu = new CalculatriceBean { NoCalculatrice = int.Parse(dataReader.GetValue(0).ToString()), Modele = dataReader.GetValue(1).ToString() }; calculatrices.Add(calcu); } dataReader.Close(); command.Dispose(); cnn.Close(); } catch (Exception ex) { // MessageBox.Show("Can not open connection ! "); } return calculatrices; }