public void setData(int routeid, SQLConnector scon) { sCon = scon; dS = new DataSet(); RouteID = routeid; if (routeid >= 0) { lb_id.Text = "Route-ID: " + routeid; } //load Loaction Data from Server sDA_location = sCon.getLocations_List(dS, "from_location", null); sDA_location.Fill(dS, "to_location"); sDA_route = sCon.getShip_Route(dS, "route", null, routeid); //set Data to Form-Elements lBox_from_location.DataSource = dS.Tables["from_location"]; lBox_from_location.DisplayMember = "name"; lBox_from_location.ValueMember = "LocationID"; lBox_to_location.DataSource = dS.Tables["to_location"]; lBox_to_location.DisplayMember = "name"; lBox_to_location.ValueMember = "LocationID"; if (dS.Tables["route"].Rows.Count > 0) { lb_id.Text = "Route-ID: " + dS.Tables["route"].Rows[0]["RouteID"]; lBox_from_location.SelectedValue = dS.Tables["route"].Rows[0]["from_locationID"]; lBox_to_location.SelectedValue = dS.Tables["route"].Rows[0]["to_locationID"]; tB_name.Text = (string)dS.Tables["route"].Rows[0]["RouteName"]; nTB_distance.Text = ((Decimal)dS.Tables["route"].Rows[0]["distance_km"]).ToString(); } }