The following example creates a
ZohoBooksCommand, then executes it by passing a string that is SQL SELECT statement, and a string to use to connect to the data source.
|
|---|
public void CreateZohoBooksDataReader(string mySelectQuery,string ZohoBooksConnectionString)
{
ZohoBooksConnection ZohoBooksConnection = new ZohoBooksConnection(ZohoBooksConnectionString);
ZohoBooksCommand ZohoBooksCommand = new ZohoBooksCommand(mySelectQuery, ZohoBooksConnection);
ZohoBooksCommand.Connection.Open();
ZohoBooksDataReader ZohoBooksReader = ZohoBooksCommand.ExecuteReader();
try
{
while(ZohoBooksReader.Read())
{
Console.WriteLine(ZohoBooksReader.GetString(0));
}
}
finally
{
ZohoBooksReader.Close();
ZohoBooksConnection.Close();
}
} |
|
|---|
Public Sub CreateZohoBooksDataReader(mySelectQuery As String, _
ZohoBooksConnectionString As String)
Dim ZohoBooksConnection As New ZohoBooksConnection(ZohoBooksConnectionString)
Dim ZohoBooksCommand As New ZohoBooksCommand(mySelectQuery, ZohoBooksConnection)
ZohoBooksCommand.Connection.Open()
Dim ZohoBooksReader As ZohoBooksDataReader = ZohoBooksCommand.ExecuteReader()
Try
While ZohoBooksReader.Read()
Console.WriteLine(ZohoBooksReader.GetString(0))
End While
Finally
ZohoBooksReader.Close()
ZohoBooksConnection.Close()
End Try
End Sub |
