'Declaration Public Function New( _ ByVal selectCommand As MySqlCommand _ )
public MySqlDataTable( MySqlCommand selectCommand )
Parameters
- selectCommand
- A MySqlCommand object used to select rows from the data source.
'Declaration Public Function New( _ ByVal selectCommand As MySqlCommand _ )
public MySqlDataTable( MySqlCommand selectCommand )
public void UseDataTable(MySqlConnection myConnection) { MySqlCommand myCommand = new MySqlCommand("SELECT * FROM Test.Dept",myConnection); MySqlDataTable myDataTable = new MySqlDataTable(myCommand); try { myDataTable.Active = true; foreach(DataRow myRow in myDataTable.Rows) { foreach(DataColumn myCol in myDataTable.Columns) { Console.Write(myRow[myCol]+"\t"); } Console.WriteLine(); } } finally { myDataTable.Active = false; } }
Public Sub UseDataTable(ByVal myConnection As MySqlConnection) Dim myCommand As MySqlCommand = New MySqlCommand("SELECT * FROM Test.Dept", myConnection) Dim myDataTable As MySqlDataTable = New MySqlDataTable(myCommand) Try myDataTable.Active = True Dim myRow As DataRow Dim myCol As DataColumn For Each myRow In myDataTable.Rows For Each myCol In myDataTable.Columns Console.Write(myRow(myCol) & Chr(9)) Next myCol Console.WriteLine() Next myRow Finally myDataTable.Active = False End Try End Sub