public DataTable mostrar() { cmd.Connection = conex.Abrirconex(); cmd.CommandText = "CargarTodos"; cmd.CommandType = CommandType.StoredProcedure; dr = cmd.ExecuteReader(); dt.Load(dr); conex.Cerraconex(); return(dt); }