public void delete(Modelo.AlunoDocumento obj) { SqlConnection conn = new SqlConnection(connectionString); conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "DELETE FROM AlunoDocumento WHERE IdAluno=@IdAluno AND IdDocumento=@IdDocumento"; cmd.Parameters.AddWithValue("@IdDocumento", obj.idDocumento); cmd.Parameters.AddWithValue("@IdAluno", obj.idAluno); cmd.ExecuteNonQuery(); conn.Close(); }
public void insert(Modelo.AlunoDocumento alunoDocumento) { SqlConnection conn = new SqlConnection(connectionString); conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "INSERT INTO AlunoDocumento (IdAluno,IdDocumento) VALUES (@IdAluno,@IdDocumento)"; cmd.Parameters.AddWithValue("@IdAluno", alunoDocumento.idAluno); cmd.Parameters.AddWithValue("@IdDocumento", alunoDocumento.idDocumento); cmd.ExecuteNonQuery(); conn.Close(); }