public void setData(int passengerid, int sellerID, SQLConnector scon) { sCon = scon; dS = new DataSet(); PassengerID = passengerid; if (passengerid >= 0) { lb_id.Text = "Passenger-ID: " + passengerid; } //load DataSets sDA_sellers = sCon.getSellers_List_FullName(dS, null); sDA_customers = sCon.getCustomers_List_FullName(dS, null); sDA_passenger = sCon.getPassenger(dS, "passenger", null, PassengerID); //set Data to Form-Elements lBox_customer.DataSource = dS.Tables["customers"]; lBox_customer.DisplayMember = "CustomerName"; lBox_customer.ValueMember = "CustomerID"; coB_select_seller.DataSource = dS.Tables["sellers"]; coB_select_seller.DisplayMember = "SellerName"; coB_select_seller.ValueMember = "SellerID"; if (sellerID >= 0) coB_select_seller.SelectedValue = sellerID; if (dS.Tables["passenger"].Rows.Count > 0) { if (sellerID < 0) { sDA_passenger_seller = sCon.getPassenger_Seller(dS, "passenger_seller", null, PassengerID); if (dS.Tables["passenger_seller"].Rows.Count > 0) coB_select_seller.SelectedValue = dS.Tables["passenger_seller"].Rows[0]["sellerID"]; } lb_id.Text = "Passenger-ID: " + dS.Tables["passenger"].Rows[0]["ID"]; lBox_customer.SelectedValue = dS.Tables["passenger"].Rows[0]["customerID"]; lBox_transaction.SelectedValue = dS.Tables["passenger"].Rows[0]["transactionID"]; nTB_price.Text = ((decimal)dS.Tables["passenger"].Rows[0]["price"]).ToString(); //if ((byte)dS.Tables["passenger"].Rows[0]["is_paid"] == 0) cB_is_paid.Checked = false; else cB_is_paid.Checked = true; cB_is_paid.Checked = Convert.ToBoolean((byte)dS.Tables["passenger"].Rows[0]["is_paid"]); dTP_booked_date.Value = (DateTime)dS.Tables["passenger"].Rows[0]["booked_time"]; dTP_booked_time.Value = (DateTime)dS.Tables["passenger"].Rows[0]["booked_time"]; } }