public List <WayPoints> AllWayPointsGetInfo(int MapSelection) { string MapDefinition; MapDefinition = "1"; MapDefinition = MapSelection.ToString(); string mystring = "" + (char)34; MapDefinition = MapDefinition.Replace(mystring, ""); mystring = "" + (char)47; MapDefinition = MapDefinition.Replace(mystring, ""); mystring = "" + (char)92; MapDefinition = MapDefinition.Replace(mystring, ""); //MapDefinition = "1"; List <WayPoints> SelectionItemsinfo = new List <WayPoints>(); DataSet ds = new DataSet(); int iMapDefinition = Convert.ToInt32(MapDefinition); string ConnectionString = ReturnConnectionString(); using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { string SqlCommandText = "[WebSite].[AllWayPointsGetInfo]"; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = SqlCommandText; cmd.Parameters.AddWithValue("@MapDefinition", iMapDefinition); cmd.Connection = con; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds, "SelectionItems"); } } } if (ds != null) { if (ds.Tables.Count > 0) { if (ds.Tables["SelectionItems"].Rows.Count > 0) { foreach (DataRow dr in ds.Tables["SelectionItems"].Rows) { SelectionItemsinfo.Add(new WayPoints { WayPointID = Convert.ToInt32(dr["WayPointsID"]), WayPointName = dr["WayPointName"].ToString(), Latitude = Convert.ToDouble(dr["Latitude"]), Longitude = Convert.ToDouble(dr["Longitude"]), FishingText = dr["FishingText"].ToString(), BestWindText = dr["BestWindText"].ToString(), TypeOfFishingText = dr["TypeOfFishingText"].ToString(), }); } } } } return(SelectionItemsinfo); }