cod_banco_CRUDJG

Prévia do material em texto

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;
namespace SimuladoProvaCsharp_3.Dados
{
 public class Banco
 {
 private string conexao = 
@"Server=DESKTOP-F6SV37U;Database=CadastroDB_2;Trusted_Connection=True;";
 public DataTable ExecutarSelect(string procedure, SqlParameter[] 
parametros = null)
 {
 using (SqlConnection conn = new SqlConnection(conexao))
 {
 SqlCommand cmd = new SqlCommand(procedure, conn);
 cmd.CommandType = CommandType.StoredProcedure;
 if(parametros != null)
 {
 cmd.Parameters.AddRange(parametros);
 }
 SqlDataAdapter da = new SqlDataAdapter(cmd);
 DataTable dt = new DataTable();
 da.Fill(dt);
 return dt;
 }
 }
 public int ExecutarComando(string procedure, SqlParameter[] parametros =
null)
 {
 using (SqlConnection conn = new SqlConnection(conexao))
 {
 conn.Open();
 SqlCommand cmd = new SqlCommand(procedure, conn);
 cmd.CommandType = CommandType.StoredProcedure;
 if (parametros != null)
 {
 cmd.Parameters.AddRange(parametros);
 }
 return cmd.ExecuteNonQuery();
 }
 }
 }
}