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