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();
}
}