public static Canal SelectById(int id)
    {
        CanalDSTableAdapters.TblCanalTableAdapter adapter = new CanalDSTableAdapters.TblCanalTableAdapter();
        CanalDS.TblCanalDataTable table = adapter.SelectById(id);

        if (table.Count() == 0)
        {
            return null;
        }

        Canal objCanal = RowToDto(table[0]);

        return CargarInformacionCompleta(objCanal);
    }