The following example creates a
MySqlCommand, 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 CreateMySqlDataReader(string mySelectQuery,string mySqlConnectionString)
{
MySqlConnection mySqlConnection = new MySqlConnection(mySqlConnectionString);
MySqlCommand mySqlCommand = new MySqlCommand(mySelectQuery, mySqlConnection);
mySqlCommand.Connection.Open();
MySqlDataReader mySqlReader = mySqlCommand.ExecuteReader();
try
{
while(mySqlReader.Read())
{
Console.WriteLine(mySqlReader.GetString(0));
}
}
finally
{
mySqlReader.Close();
mySqlConnection.Close();
}
} |
|
|---|
Public Sub CreateMySqlDataReader(mySelectQuery As String, _
mySqlConnectionString As String)
Dim mySqlConnection As New MySqlConnection(mySqlConnectionString)
Dim mySqlCommand As New MySqlCommand(mySelectQuery, mySqlConnection)
mySqlCommand.Connection.Open()
Dim mySqlReader As MySqlDataReader = mySqlCommand.ExecuteReader()
Try
While mySqlReader.Read()
Console.WriteLine(mySqlReader.GetString(0))
End While
Finally
mySqlReader.Close()
mySqlConnection.Close()
End Try
End Sub |