private void button6_Click(object sender, EventArgs e) { try { DBManager manager = new DBManager(); SqlConnection connection = manager.Connection(); string selectQuery = "SELECT Book_Name,Writer,Edition,Quantity from Orders"; SqlCommand cmd = new SqlCommand(selectQuery, connection); connection.Open(); List <Order> orders = new List <Order>(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string bookName = reader[0].ToString(); string writerName = reader[1].ToString(); string edition = reader[2].ToString(); string qu = reader[3].ToString(); int quantity = Convert.ToInt16(qu); Order anOrder = new Order(); anOrder.BookName = bookName; anOrder.WriterName = writerName; anOrder.Edition = edition; anOrder.Quantity = quantity; orders.Add(anOrder); } QuantitySelect aQuantitySelect = new QuantitySelect(orders); aQuantitySelect.ShowDialog(); } catch (SqlException exception) { MessageBox.Show(exception.Message); } }
private void button6_Click_1(object sender, EventArgs e) { try { DBManager manager = new DBManager(); SqlConnection connection = manager.Connection(); string selectQuery = "SELECT Book_Name,Writer,Edition,Quantity from Orders"; SqlCommand cmd = new SqlCommand(selectQuery, connection); connection.Open(); List<Order> orders = new List<Order>(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string bookName = reader[0].ToString(); string writerName = reader[1].ToString(); string edition = reader[2].ToString(); string qu = reader[3].ToString(); int quantity = Convert.ToInt16(qu); Order anOrder = new Order(); anOrder.BookName = bookName; anOrder.WriterName = writerName; anOrder.Edition = edition; anOrder.Quantity = quantity; orders.Add(anOrder); } QuantitySelect aQuantitySelect = new QuantitySelect(orders); aQuantitySelect.ShowDialog(); } catch (SqlException exception) { MessageBox.Show(exception.Message); } }