SQLiteConnectionExtensionsToDataTable Method
Converts the source SQLiteConnection to DataTable.
Namespace: DevCase.ThirdParty.SQLite.Extensions.SQLiteConnectionExtensionsAssembly: DevCase.net48.ThirdParty.SQLite (in DevCase.net48.ThirdParty.SQLite.dll) Version: 6.0.0.0 (6.0)
XMLNS for XAML: Not mapped to an xmlns.
[EditorBrowsableAttribute(EditorBrowsableState.Always)]
public static DataTable ToDataTable(
this SQLiteConnection sqlConn,
string tableName = ""
)
<ExtensionAttribute>
<EditorBrowsableAttribute(EditorBrowsableState.Always)>
Public Shared Function ToDataTable (
sqlConn As SQLiteConnection,
Optional tableName As String = ""
) As DataTable
Dim sqlConn As SQLiteConnection
Dim tableName As String
Dim returnValue As DataTable
returnValue = sqlConn.ToDataTable(tableName)
public:
[ExtensionAttribute]
[EditorBrowsableAttribute(EditorBrowsableState::Always)]
static DataTable^ ToDataTable(
SQLiteConnection^ sqlConn,
String^ tableName = L""
)
[<ExtensionAttribute>]
[<EditorBrowsableAttribute(EditorBrowsableState.Always)>]
static member ToDataTable :
sqlConn : SQLiteConnection *
?tableName : string
(* Defaults:
let _tableName = defaultArg tableName ""
*)
-> DataTable
No code example is currently available or this language may not be supported.
- sqlConn SQLiteConnection
-
The source SQLiteConnection.
- tableName String (Optional)
-
The name of the table to convert.
tableName parameter can be null if sqlConn only contains a single table.
If sqlConn contains more than one table and tableName parameter is null,
an exception will be thrown.
DataTable
The resulting
DataTableIn Visual Basic and C#, you can call this method as an instance method on any object of type
SQLiteConnection. When you use instance method syntax to call this method, omit the first parameter. For more information, see
Extension Methods (Visual Basic) or
Extension Methods (C# Programming Guide).
This is a code example to automate Firefox borwser.
No code example is currently available or this language may not be supported.
Dim db As System.Data.SQLite.SQLiteConnection = SqLiteUtil.OpenDatabase("C:\Database.db")
Dim dt As DataTable = ToDataTable(db, "Table Name")
For Each row As DataRow In dt.Rows
Console.WriteLine(String.Join("; ", row.ItemArray))
Next row
No code example is currently available or this language may not be supported.
No code example is currently available or this language may not be supported.
No code example is currently available or this language may not be supported.
No code example is currently available or this language may not be supported.