public string RetornarConsulta(string xQuery, string NomeTabela, string ConexaoOracle)
{
string Resposta = "0";
SqlConnection DB = new SqlConnection(DecriptaString(ConexaoOracle));
SqlCommand Cmd = new SqlCommand();
SqlDataReader Dre;
DB.Open();
Cmd.Connection = DB;
Cmd.CommandText = xQuery;
Dre = Cmd.ExecuteReader();
if (Dre.Read())
{
Resposta = Dre[0].ToString();
}
//Resposta = Cmd.ExecuteScalar(); //ANTIGO
DB.Close();
DB.Dispose();
return Resposta;
}