public static DataTable GetBySql(string sql) { ServiceReference1.FileTransportServiceClient ft = new ServiceReference1.FileTransportServiceClient(); try { byte[] da = ft.GetBySql(sql); DataTable dt = ToDataTable(da); dt.TableName = "dt"; return(dt); } catch (Exception ex) { return(new DataTable()); } finally { ft.Close(); } }