Represents a SQL statement or stored procedure to execute against a database.
The following example uses the
ExecuteReader method of
UniCommand, along with
UniDataReader and
UniConnection, to select rows from a table.
public void ReadMyData(string myConnString)
{
string mySelectQuery = "SELECT * FROM Test.Dept";
UniConnection myConnection = new UniConnection(myConnString);
UniCommand myCommand = new UniCommand(mySelectQuery,myConnection);
myConnection.Open();
UniDataReader myReader = myCommand.ExecuteReader();
try
{
while (myReader.Read())
{
Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1));
}
}
finally
{
// always call Close when done reading.
myReader.Close();
// always call Close when done reading.
myConnection.Close();
}
}
Public Sub ReadMyData(myConnString As String)
Dim mySelectQuery As String = "SELECT * FROM Test.Dept"
Dim myConnection As New UniConnection(myConnString)
Dim myCommand As New UniCommand(mySelectQuery, myConnection)
myConnection.Open()
Dim myReader As UniDataReader = myCommand.ExecuteReader()
Try
While myReader.Read()
Console.WriteLine(myReader.GetInt32(0).ToString() + ", " _
+ myReader.GetString(1))
End While
Finally
' always call Close when done reading.
myReader.Close()
' always call Close when done with connection.
myConnection.Close()
End Try
End Sub