public void setData(int offerid, SQLConnector scon) { sCon = scon; dS = new DataSet(); OfferID = offerid; if (offerid >= 0) { lb_id.Text = "Offer-ID: " + offerid; } //load tours, offer Data from Server sDA_tour = sCon.getShip_Tours_List(dS, null); sDA_offer = sCon.getOffer(dS, "offer", null, OfferID); lBox_tour.DataSource = dS.Tables["ship_tours"]; lBox_tour.DisplayMember = "TourName"; lBox_tour.ValueMember = "TourID"; if (dS.Tables["offer"].Rows.Count > 0) { lb_id.Text = "Offer-ID: " + dS.Tables["offer"].Rows[0]["ID"]; lBox_tour.SelectedValue = dS.Tables["offer"].Rows[0]["tourID"]; dTP_createDate.Value = (DateTime)dS.Tables["offer"].Rows[0]["create_date"]; dTP_createTime.Value = (DateTime)dS.Tables["offer"].Rows[0]["create_date"]; dTP_expireDate.Value = (DateTime)dS.Tables["offer"].Rows[0]["expire_date"]; dTP_expireTime.Value = (DateTime)dS.Tables["offer"].Rows[0]["expire_date"]; nTB_price.Text = ((Decimal)dS.Tables["offer"].Rows[0]["price"]).ToString(); tB_name.Text = (string)dS.Tables["offer"].Rows[0]["name"]; } }