Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void UpdateOrder_Load(object sender, EventArgs e)
- {
- this.ordersTableAdapter.Fill(this.aSPNETDB_DataSet.Orders);
- IDOrder orderIDFrm = new IDOrder();
- orderIDFrm.ShowDialog();
- OrderID = orderIDFrm.ReturnedID;
- if (OrderID != 0)
- {
- Text = "Order " + OrderID.ToString();
- SqlConnection connection = CreateConnection();
- using (connection)
- {
- SqlCommand command = new SqlCommand(
- "SELECT OrderID, UserName, CustEmail, ProdName, ProdPrice, Quantity, ShipperName, PaymentTypeName, OrderDate, DeliveryNotes, OrderAmount FROM Orders WHERE OrderID=@ordID", connection
- );
- SqlParameter par = new SqlParameter("@ordID", SqlDbType.Int);
- par.Value = OrderID;
- command.Parameters.Add(par);
- try
- {
- connection.Open();
- SqlDataReader reader = command.ExecuteReader();
- while (!reader.HasRows)
- {
- orderIDFrm.Dispose();
- MessageBox.Show("There is no product with this ID! Please enter an existing ID!");
- orderIDFrm.ShowDialog();
- }
- if (reader.HasRows)
- {
- DataTable dt = new DataTable();
- dt.Load(reader);
- ordersDataGridView.DataSource = dt;
- }
- reader.Close();
- }
- catch (SqlException se)
- {
- MessageBox.Show(se.Message.ToString());
- }
- }
- orderIDFrm.Dispose();
- }
- else if (OrderID == 0)
- {
- //orderIDFrm.Dispose();
- this.BeginInvoke(new MethodInvoker(orderIDFrm.Dispose));
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement