FetchAll Property (MySqlCommand)
Gets or sets a value indicating whether the
MySqlDataReader object will request data from the server on execution
ExecuteReader method.
|
|---|
'Declaration
Public Property FetchAll As Boolean |
|
|---|
public bool FetchAll {get; set;} |
Property Value
true, if the
MySqlDataReader object will request data from the server on execution
ExecuteReader; otherwise
false. The default value is
false.
The following example fills a
MySqlDataReader and renders data to console. This sample demonstrates ability to navigate through the
MySqlDataReader (this can be done several times) when
FetchAll property is set to
true.
|
|---|
public void FetchThemAll(MySqlConnection myConnection)
{
MySqlCommand cmd = new MySqlCommand("SELECT EmpNo, EName FROM Emp");
cmd.FetchAll = true;
cmd.Connection = myConnection;
myConnection.Open();
MySqlDataReader reader = cmd.ExecuteReader();
foreach (IDataRecord rec in reader)
{
Console.Write(rec["EmpNo"]);
Console.WriteLine("\t"+rec["EName"]);
}
} |
|
|---|
Public Sub FetchThemAll(ByVal myConnection As MySqlConnection)
Dim cmd As MySqlCommand = New MySqlCommand("SELECT EmpNo, EName FROM Emp")
cmd.FetchAll = True
cmd.Connection = myConnection
myConnection.Open()
Dim reader As MySqlDataReader = cmd.ExecuteReader()
For Each rec As IDataRecord In reader
Console.Write(rec("EmpNo"))
Console.WriteLine(String.Concat(" ", rec("EName")))
Next
End Sub |
