Example #1
0
 public static void ExecutaSQL(string sql, SqlParameter[] parametros)
 {
     using (SqlConnection conexao = ConexaoBD.GetConexao())
     {
         using (SqlCommand comando = new SqlCommand(sql, conexao))
         {
             if (parametros != null)
             {
                 comando.Parameters.AddRange(parametros);
             }
             comando.ExecuteNonQuery();
         }
         conexao.Close();
     }
 }
Example #2
0
 public static DataTable ExecutaSelect(string sql, SqlParameter[] parametros)
 {
     using (SqlConnection conexao = ConexaoBD.GetConexao())
     {
         using (SqlDataAdapter adapter = new SqlDataAdapter(sql, conexao))
         {
             if (parametros != null)
             {
                 adapter.SelectCommand.Parameters.AddRange(parametros);
             }
             DataTable tabela = new DataTable();
             adapter.Fill(tabela);
             conexao.Close();
             return(tabela);
         }
     }
 }