private static void Ingresar(Biblioteca biblio) { SqlCommand cmd; SqlDataReader rd; string insert; string select; insert = "insert into Biblioteca (cNombre, cDescripcion) values ('" + biblio.Nombre + "', '" + biblio.Descripcion + "')"; select = "select IDENT_CURRENT ('Biblioteca')"; cmd = new SqlCommand(insert, BD.Con); cmd.ExecuteNonQuery(); cmd = new SqlCommand(select, BD.Con); rd = cmd.ExecuteReader(); rd.Read(); biblio.BibliotecaId = Convert.ToInt32(rd [0]); rd.Close(); }
public static Biblioteca BuscarPorId(int id) { SqlCommand cmd; SqlDataReader rd; string select; Biblioteca biblio = null; select = "select * from Biblioteca where iBibliotecaId =" + id; cmd = new SqlCommand(select, BD.Con); rd = cmd.ExecuteReader(); if (rd.Read()) { biblio = new Biblioteca(); biblio.BibliotecaId = id; biblio.Nombre = rd [1].ToString(); biblio.Descripcion = rd [2].ToString(); rd.Close(); } return(biblio); }