The following example creates a
SugarCommand, 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 CreateSugarDataReader(string mySelectQuery,string sugarConnectionString)
{
SugarConnection sugarConnection = new SugarConnection(sugarConnectionString);
SugarCommand sugarCommand = new SugarCommand(mySelectQuery, sugarConnection);
sugarCommand.Connection.Open();
SugarDataReader sugarReader = sugarCommand.ExecuteReader();
try
{
while(sugarReader.Read())
{
Console.WriteLine(sugarReader.GetString(0));
}
}
finally
{
sugarReader.Close();
sugarConnection.Close();
}
} |
|
|---|
Public Sub CreateSugarDataReader(mySelectQuery As String, _
sugarConnectionString As String)
Dim sugarConnection As New SugarConnection(sugarConnectionString)
Dim sugarCommand As New SugarCommand(mySelectQuery, sugarConnection)
sugarCommand.Connection.Open()
Dim sugarReader As SugarDataReader = sugarCommand.ExecuteReader()
Try
While sugarReader.Read()
Console.WriteLine(sugarReader.GetString(0))
End While
Finally
sugarReader.Close()
sugarConnection.Close()
End Try
End Sub |
