Seal Report Library
Namespaces
Seal.Helpers
Helper Class
Helper Methods
AddAttribute Method
AddCTE Method
AddEmailAddresses Method
AddIfNotEmpty Method
AddIfNotNull Method
AddNotEmpty Method
AddNotEmpty2 Method
AddValue Method
AreEqualToSecond Method
ArePropertiesIdentical Method
CleanFileName Method
ClearAllLINQKeywords Method
ClearAllSQLKeywords Method
ClearSQLKeywords Method
Clone Method
CompareTrim Method
ConcatCellValues Method
ConvertDateTimeStandardFormat Method
ConvertNumericStandardFormat Method
CopyProperties Method
CopyPropertiesDifferentObjects Method
CopyPropertiesFromReference Method
DatabaseToNetTypeConverter Method
DbConnectionFromConnectionString Method
DBNameToDisplayName Method
DisplayDataTable Method
EscapeInlineScript Method
EscapeSQLStringLiteral Method
ExecutePrePostSQL Method
FindReplacePattern Method
FirstNotEmpty Method
FormatMessage Method
FromTimeSpan Method
GetApplicationDirectory Method
GetCssResourceMimeType Method
GetDatabaseType Method
GetDataTable Method
GetEmailAddresses Method
GetEnumDescription Method
GetEnumFromDescription<T> Method
GetExceptionMessage Method
GetLicense Method
GetLicenseText Method
GetMongoConnectionString Method
GetMySQLConnectionString Method
GetOdbcConnectionString Method
GetOleDbConnectionString Method
GetPropertyValue Method
GetSQLKeywordNames Method
GetStaticPropertyValue Method
GetStringList Method
GetSystemDriverList Method
GetUniqueName Method
GetUniqueNameCaseInsensitive Method
GetVals Method
HasTimeFormat Method
HtmlGetFilePath Method
HtmlMakeImageSrcData Method
IfNullOrEmpty Method
InlineCssUrls Method
IsMachineAdministrator Method
IsMatchWildcard Method
IsPasswordComplex Method
IsValidOS Method
MaskEmail Method
MaskPhoneNumber Method
NetTypeConverter Method
NewGUID Method
ODBCToNetTypeConverter Method
OdbcTypeConverter Method
OleDbToNetTypeConverter Method
QuoteDouble Method
QuoteSingle Method
RemoveHTMLTags Method
RemoveWhitespace Method
Serialize Method
SetPropertyValue Method
ToCSharpVerbatimLiteral Method
ToDateFnsFormat Method
ToDateTime Method
ToDouble Method
ToFlatpickrFormat Method
ToHtml Method
ToHtmlNoBr Method
ToJS Method
ToMomentJSFormat Method
ToString Method
ToTimeSpan Method
ValidateNumeric Method
WriteDailyLog Method
WriteEventLogEntry Method
WriteLogEntry Method
WriteLogEntryScheduler Method
WriteLogException Method
Click or drag to resize

HelperGetDataTable Method

Load a DataTable from a SQL statement executed on a database connection

Namespace: Seal.Helpers
Assembly: SealLibrary (in SealLibrary.dll) Version: 10.2.0.0+da7797057e6d5ef3b02633ee3e36991921c726cb
Syntax
C#
Copy
public static DataTable GetDataTable(
	DbConnection connection,
	string sql
)

Parameters

connection  DbConnection
 
sql  String
 

Return Value

DataTable
See Also