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