Пример #1
0
        private void OrdersIDBox_SelectedIndexChanged(object sender, EventArgs e)
        {
            dataGridView1.Rows.Clear();

            if (OrdersIDBox.SelectedItem != null)
            {
                String ID = OrdersIDBox.GetItemText(OrdersIDBox.SelectedItem);
                query1 = "select * from SingleOrder where ID = '" + ID + "'";
                DataSet ds = db.getData(query1);

                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    dataGridView1.Rows.Add();
                }

                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    dataGridView1.Rows[i].Cells[0].Value = ds.Tables[0].Rows[i][0].ToString();
                    dataGridView1.Rows[i].Cells[1].Value = ds.Tables[0].Rows[i][1].ToString() + "€";
                    dataGridView1.Rows[i].Cells[2].Value = ds.Tables[0].Rows[i][2].ToString();
                    dataGridView1.Rows[i].Cells[3].Value = ds.Tables[0].Rows[i][3].ToString() + "€";
                    dataGridView1.Rows[i].Cells[4].Value = ds.Tables[0].Rows[i][4].ToString();
                }
                dataGridView1.ClearSelection();

                query1       = "select TotalCost from TotalOrders where ID = '" + ID + "'";
                ds           = db.getData(query1);
                ValueLb.Text = ds.Tables[0].Rows[0][0].ToString() + "€";
            }
        }
Пример #2
0
 private void OrdersUC_Leave(object sender, EventArgs e)
 {
     dataGridView1.ClearSelection();
     OrdersIDBox.ClearSelected();
     ValueLb.Text = "0€";
 }