using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;

namespace WebPedidos
{
    public class PesquisaDrop
    {

        public DataSet RetornaDataSet(string StrSqlQuery)
        {

            Conexao conexao = new Conexao();
            SqlConnection ObjCnn = conexao.getConexao();
            try
            {
                SqlCommand Cnn = new SqlCommand(StrSqlQuery, ObjCnn);
                SqlDataAdapter adapter = new SqlDataAdapter(Cnn);
                DataSet dataSet = new DataSet();
                adapter.Fill(dataSet);
                return dataSet;
            }
            catch
            {
                return null;
            }
        }
    }

}