public DataSet ExecuteQuery(string commandText)
{
DataSet ds = new DataSet();
using (var connection = new MySqlConnection(connString))
{
connection.Open();
var command = connection.CreateCommand();
command.CommandText = commandText;
using (var data = new MySqlDataAdapter { SelectCommand = command })
{
data.Fill(ds);
connection.Close();
}
}
return ds;
} |
public DataSet ExecuteQuery(string commandText)
{
DataSet ds = new DataSet();
using (var connection = new MySqlConnection(connString))
{
connection.Open();
var command = connection.CreateCommand();
command.CommandText = commandText;
using (var data = new MySqlDataAdapter { SelectCommand = command })
{
data.Fill(ds);
connection.Close();
}
}
return ds;
}
n. 1: automatic, but with an element of magic. 2: too complex to understand and/or explain