Torna al Thread
using System.Data.OleDb;
//...
public DataSet createParametricalDataSet(string sqlQuery, OleDbParameter[] parameters)
{
using (OleDbConnection myConnection = new OleDbConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
using (OleDbCommand command = new OleDbCommand(sqlQuery, myConnection))
{
foreach (OleDbParameter indx in parameters)
{
command.Parameters.Add(indx);
}
myConnection.Open();
DataSet dataSet = new DataSet();
using (OleDbDataAdapter adapter = new OleDbDataAdapter(command))
{
adapter.Fill(dataSet);
}
myConnection.Close();
return dataSet;
}
}
}